Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous