Question

For which type are illegal values converted to the appropriate ‘zero’ value?

(a) Numeric

(b) String

(c) ENUM

(d) TIME

I have been asked this question in an interview.

I want to ask this question from How MySQL Handles Invalid Data Values in division Data Types of MySQL

Answer 1

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.