Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

205

积分

14

好友

29

主题
发表于 2016-6-25 18:15:39 | 查看: 989| 回复: 1
【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正确。
dbdao_mysql_item77_1_wm.png

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

参考:
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
发表于 2016-9-16 16:46:33
版主分析的很好呀,为什么不继续更新

回复 显示全部楼层 道具 举报

您需要登录后才可以回帖 登录 | 注册

扫码加入微信Oracle小密圈


QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2018-1-23 14:10 , Processed in 0.071397 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569