Question

Which mode is a shorthand for ‘both strict modes plus a bunch of other restrictions’?

(a) STRICT_ALL_TABLES

(b) STRICT_TRANS_TABLES

(c) TRADITIONAL

(d) ERROR_WHEN_DIVIDE_BY_ZERO

I got this question by my college director while I was bunking the class.

This intriguing question originated from How MySQL Handles Invalid Data Values in section Data Types of MySQL

Answer 1

Correct choice is (c) TRADITIONAL

To explain: In MySQL, the ‘TRADITIONAL’ mode is used to enable the strict mode. It also enables all of the additional restrictions by the command ‘SET sql_mod = ‘TRADITIONAL” The other SQL modes have other functions.