For which type are illegal values converted to the appropriate ‘zero’ value?
(a) Numeric
(b) String
(c) ENUM
(d) TIME
(a) Numeric
(b) String
(c) ENUM
(d) TIME
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Correct choice is (d) TIME
The best explanation: In MySQL, there are different ways to handle the illegal values for different datatypes for default. For date or time columns, illegal values are converted to the appropriate “zero” value for the type.