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

STRICT_ALL_TABLES turns on stricter checking of data values.

Answer & Solution
Correct Answer: Option A
This question asks about the STRICT_ALL_TABLES setting in MySQL.
STRICT_ALL_TABLES is a setting that makes MySQL more strict about the data it accepts. This means that if you try to insert data that doesn't fit the column's rules (like trying to put a letter in a number column), MySQL will likely give you an error and refuse to save the data.
So, the answer to this question is True.
STRICT_ALL_TABLES does indeed turn on stricter checking of data values.
Example:
Let's say you have a table with a column called "age" that is defined as an integer.
If STRICT_ALL_TABLES is ON, you wouldn't be able to insert the value "abc" into the "age" column, as it is a string and not an integer.
This helps ensure data integrity by preventing invalid data from entering your database.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.