多项选择题

What are three methods to reduce Mysql server exposure to remote connections?（）

A.Setting — skip-networking when remote connections are not required
B.Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
C.Setting specific GRANT privilege to limit remote authentication
D.Setting – mysql_secure_configuration to enable paranoid mode
E.Using SSL when transporting data over remote networks

<上一题目录下一题>

热门试题

单项选择题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

单项选择题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