Home/ Questions/Q 352260
Next
In Process
Aarushi Bharat Khosla
Asked: 2022-11-09T05:28:30+05:30 In:

The SQL mode to check for divide by zero error is ________________

(a) STRICT_ALL_TABLES

(b) ERROR_FOR_DIVISION_BY_ZERO

(c) ERROR_DIVIDE_BY_ZERO

(d) ERROR_WHEN_DIVIDE_BY_ZERO

The SQL mode to check for divide by zero error is ________________

(a) STRICT_ALL_TABLES

(b) ERROR_FOR_DIVISION_BY_ZERO

(c) ERROR_DIVIDE_BY_ZERO

(d) ERROR_WHEN_DIVIDE_BY_ZERO
Social
Leave an answer

Leave an answer

Browse

1 Answer

  1. Right answer is (b) ERROR_FOR_DIVISION_BY_ZERO

    To explain: 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’.

    • 0