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
Answer: Option C
Solution (By Examveda Team)
This question is about different modes in MySQL. Modes are like settings that change how MySQL works.The question asks which mode is like a super-strict mode that includes many extra rules.
Let's look at the options:
Option A: STRICT_ALL_TABLES - This mode applies strict rules to all tables in the database.
Option B: STRICT_TRANS_TABLES - This mode applies strict rules to transactions.
Option C: TRADITIONAL - This is the answer! It's a mode that combines the strict rules from options A and B, plus a bunch of other extra restrictions.
Option D: ERROR_WHEN_DIVIDE_BY_ZERO - This mode specifically tells MySQL to treat division by zero as an error, which is different from the general concept of strictness.
So the correct answer is Option C: TRADITIONAL.
Join The Discussion