Examveda

By default, MySQL does not clip out of range numeric values to the nearest fit value.

A. True

B. False

Answer: Option B

Solution (By Examveda Team)

This question is about how MySQL handles numbers that are too big or too small for the data type they are supposed to be.
Imagine you have a box that can only hold numbers between 0 and 10. If you try to put the number 12 in the box, what happens?
MySQL doesn't automatically adjust the number to fit. It will either give you an error or store a distorted value.
So the answer is Option A: True

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous