【dbdao.com MySQL OCP认证专题】- MySQL 5.6 - OCP 考题讲解 - 77

biotwang

【dbdao.com MySQL OCP认证专题】- MySQL 5.6 - OCP 考题讲解

77.

Which two statements describe the behavior of the server’s SQL mode?
A.
The server’s SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.
B.
The server’s SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.
C.
The server’s SQL mode can be changed at the session level with a SET SESSION sql_mode=”new_value” command.
D.
The server’s SQL mode, when globally set on a slave server, applies to events sent from the master.

答案：A, C

分析：
A对B错，Modes affect the SQL syntax MySQL supports and the data validation checks it performs. B所指的工作应该是权限设置而非SQL Mode。
The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable.
DBAs can set the global SQL mode to match site server operating requirements, and each application can set its session SQL mode to its own requirements.
C正确。

D错，从master接收的事务该怎么样还怎么样，如果是基于statement的同步，仅是涉及能否正确执行的问题，但基于Row的同步，则不会受此影响。

参考：
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

qiaolan

版主分析的很好呀，为什么不继续更新

sunguo40

两年没更新了，Mysql题库没了