Which of the following SQL data types should not be used to define the numeric data: 111.11?Question 4Select one:a.integer(3,2)b.numeric(3,2)c.numeric(4,2)d.numeric(5,2)

The correct answer is a. integer(3,2).

Here's why:

a. integer(3,2): This is not a valid data type in SQL. In SQL, the integer data type does not allow for decimal places. Therefore, it cannot be used to define the numeric data 111.11.

b. numeric(3,2): This data type allows for 3 digits in total, of which 2 are decimal places. This means there is only room for one digit before the decimal point, which is not enough to represent 111.11.

c. numeric(4,2): This data type allows for 4 digits in total, of which 2 are decimal places. This means there is only room for two digits before the decimal point, which is not enough to represent 111.11.

d. numeric(5,2): This data type allows for 5 digits in total, of which 2 are decimal places. This means there is room for three digits before the decimal point, which is enough to represent 111.11. Therefore, this data type could be used to define the numeric data 111.11.