Question

Illegal values converted to the appropriate ‘zero’ value for ______________

(a) Numeric

(b) String

(c) ENUM

(d) TIME

This question was addressed to me at a job interview.

This is a very interesting question from Putting Perl DBI to Work topic in portion MySQL Programs Using Perl DBI and PHP of MySQL

Answer 1

The correct answer is (d) TIME

The best I can explain: 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.