Question

By default, MySQL clips out of range numeric values to the nearest fit value.

(a) True

(b) False

I have been asked this question in final exam.

Asked question is from How MySQL Handles Invalid Data Values in portion Data Types of MySQL

Answer 1

Right choice is (a) True

To elaborate: For the numeric or TIME columns, the values that are outside the legal range are clipped to the nearest endpoint of the range. The resulting value is stored. This is the method to handle defaults for numerics.