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

Which mode prevents MySQL to perform full checking of date parts?

Answer & Solution
Correct Answer: Option B
This question is about how MySQL handles dates. Sometimes, you might enter a date that isn't completely valid, like "2023-02-30" (February only has 28 or 29 days).
MySQL has a setting that lets you decide how it should deal with these "invalid" dates.
The correct answer is Option B: ALLOW_INVALID_DATES.
Here's why:
* ALLOW_INVALID_DATES tells MySQL to accept these dates without any complaints. It will store the date as you entered it, even if it's technically incorrect.
* The other options (ALLOW_DATES_INVALID, PREVENT_DATE_CHECK, STOP_DATES_CHECK) are not actual settings in MySQL. Let me know if you have more questions!
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.