Oracle
1Z0-883 · Question #29
Which two statements describe the behavior of the server's SQL mode?
The correct answer is A. The server's SQL mode determines how the server should behave when performing data validation C. The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value". See the full explanation below for the reasoning.
Question
Which two statements describe the behavior of the server's SQL mode?
Options
- AThe server's SQL mode determines how the server should behave when performing data validation
- BThe server's SQL mode determines whether the server should be read-only or should accept commands
- CThe server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value"
- DThe server's SQL mode, when globally set on a slave server, applies to events sent from the master.
How the community answered
(41 responses)- A73% (30)
- B17% (7)
- D10% (4)
Community Discussion
No community discussion yet for this question.