Oracle
1Z0-883 · Question #20
Which three statements describe how the strict SQL mode provides added security?
The correct answer is A. It rejects statements that try to insert out-of-range values B. It rejects invalid dates. E. It rejects dates with zero day or month values. Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE but not queries
MySQL Configuration and Architecture
Question
Which three statements describe how the strict SQL mode provides added security?
Options
- AIt rejects statements that try to insert out-of-range values
- BIt rejects invalid dates.
- CIt limits the operations that the server can perform.
- DIt rejects queries that produce out-of-range values.
- EIt rejects dates with zero day or month values.
How the community answered
(47 responses)- A72% (34)
- C19% (9)
- D9% (4)
Explanation
Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE but not queries
Topics
#strict SQL mode#sql_mode#data validation#INSERT restrictions
Community Discussion
No community discussion yet for this question.