Consider the case of a fruit juice company. The company manufactures fruit juices and supplies them
to wholesalers. The Database Designer creates a table named Production. The code is given below:
1.CREATE Table Production
2.(Fruit_type VarChar,
3.Fruit_name Char(20),
4.Quantity Int(3))
Which of the above-mentioned lines has an error?
A.
Line 3
B.
Line 2
C.
Line 1
D.
Line 4
Explanation:
In line 2, Fruit_type is declared as VarChar. A VarChar datatype should always specify the maximum
length of the column. However, in this case, the maximum length has not been specified.