A.AB.BC.CD.DThe following commands are available in the……

单项选择题The validate_password plugin is loaded and displays the following settings in global variables: Mysql＞ SHOW VARIABLES LIKE ‘validate_password%’; When attempting to set your password, you get the following error: Mysql＞ SET PASSWORD = PASSWORD (‘Hoverl@%’); ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?（）

A.The password is eight characters long, but needs to exceed validate_password_length to be valid
B.All of the MEDIUM password policy requirements have not been honored
C.The password matches a substring Hover as a dictionary word
D.The password does not match the validate_passoword_number_count requirement
E.There is no dictionary file defined, so password validation cannot work as expected

单项选择题You want a record of all queries that are not using indexes. How would you achieve this?（）

A.By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B.By enabling the Error Log because not using indexes is an error
C.By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D.By enabling the Error Log and using the – log-queries-not-using-indexes option

多项选择题Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data. This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I O overhead. What three changes will reduce disk I O overheads?（）

A.Use of soft links for database directories on the same physical disk
B.Use of delay_key_write=ON for batch index update
C.Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D.Placement of InnoDB log files and datadir on separate physical disks
E.Use of separate directories on the same physical disk for log files and data files

单项选择题Consider the following table: Which method should used to add a new g201305 partition to the table?（）

A.A
B.B
C.C
D.D
E.E

多项选择题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）

A.File system snapshots
B.Mysqldumpslow
C.Mysqlhotcopy
D.Mysqldump with – binary-data option
E.Mysql Enterprise Backup