单项选择题
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）
A.Start the server with the – innodb_recover_options option set to FORCE
B.Start the server with the – innodb_force_recovery option set to a non-zero value
C.Start the server as usual, and then execute the REPAIR TABLE command
D.Start the server as usual, and then execute the CHECK TABLE command
相关考题
-
多项选择题
Which three statements describe how the strict SQL mode provides added security?（）
A.It rejects statements that try to insert out-of-range values
B.It rejects invalid dates
C.It limits the operations that the server can perform
D.It rejects queries that produce out-of-range values
E.It rejects dates with zero day or month values -
单项选择题
The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?（）
A.A
B.B
C.C
D.D -
单项选择题
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
