ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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

Answer & Solution
Correct Answer: Option C
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.