多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATECThe server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value commandDThe server's SQL mode, when globally set on a slave server, applies to events sent from the master
多选题
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
参考解析
解析：
暂无解析
相关考题：
多选题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）AShell＞ mysqladmin –u root –p shutdownBShell＞ nmc mysql shutdownCMysql＞ STOP PROCESS mysqldDShell＞ /etc/init.d/mysql stopEShell＞ service mysql safe_exitFShell＞ pkill –u mysql mysqld_safeGShell＞ net stop mysql
多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATECThe server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value commandDThe server's SQL mode, when globally set on a slave server, applies to events sent from the master
单选题Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?（）AIt implements High Availability by using the .NET Connector's' load balancing capabilitiesBIt is shared-nothing architectureCIt is provided by means of IP- level disk replicationDIt relies on the shared disk architecture being visible to both servers
单选题What is true regarding InnoDB locking?（）AInnoDB uses row and table-level locks, but row locks are not escalatesBInnoDB locks only those rows that are updatedCInnoDB only uses row locks, not page or table-level locksDInnoDB row locks may be escalated to page or table-level locksEInnoDB uses row-level or table-level locks depending on the number of rows affected
多选题Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）ABoth technologies guarantee an identical copy of data on the secondary nodeBOnly MySQL can maintain a time-delayed copy of data on the secondary nodeCBoth technologies use the TCP/IP stack as their primary transmission mediumDDRBD uses shared-disk technology
多选题Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?（）AFORCE_PLUS_PERMANENT is not valid for the audit-log optionBThe audit_log.so library does not existCThe audit_log.so library is in a location that is different from that defined by the plugin_dir optionDThe audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandEThe audit log file does not exist in which to write audit eventsFThe audit_log.so library is not an executable file
单选题You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）AIt exports tables with the most indexes first to assist with import speedsBIt ensures that unique indexes have no conflicts when the data is dumpedCIt orders by primary key to assist in speeding up importing to InnoDB tablesDIt must be specified so index data is dumped correctly when –on-create-info is used