Question

What is the SQL mode to check for divide by zero error?

(a) STRICT_ALL_TABLES

(b) ERROR_FOR_DIVISION_BY_ZERO

(c) ERROR_DIVIDE_BY_ZERO

(d) ERROR_WHEN_DIVIDE_BY_ZERO

The question was asked by my school teacher while I was bunking the class.

Asked question is from Updating MySQL in chapter General MySQL Administration of MySQL

Answer 1

Right answer is (b) ERROR_FOR_DIVISION_BY_ZERO

For explanation I would say: To enable the check for divide by zero errors int all the storage engines, the SQL mode named ‘ERROR_FOR_DIVISION_BY_ZERO’ can be enabled. This is done by using SET sql_mode = ‘mode_name’.