Activating the MySQL Enterprise thread pool plugin
Relocating your data and log files to separate storage devices
Disconnecting idle localhost client sessions
Implementing storage engine data compression options
第1题:
A.MySQL requires correct file ownership while remaining secure
B.MySQL needs to be run as the root user, but file cannot be owned by it
C.MySQL cannot be run as the root user
第2题:
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
第3题:
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?()
A.Activating the MySQL Enterprise thread pool plugin
B.Relocating your data and log files to separate storage devices
C.Disconnecting idle localhost client sessions
D.Implementing storage engine data compression options
第4题:
Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()
第5题:
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.You run the following statements in the mydb database: Mysql> CALL prepare_db ( );Mysql> LOAD DATA INFILE ‘/tmp/data.cav‘ INTO TABLE mytable; Mysql> SHOW TABLES;How many events are added to the audit log as a result of the preceding statements?()
A.12; only top-level statements and stored procedure events are logged
B.111; top-level statements and all lower-level statements are logged
C.3; only the top-level statements are logged
D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
第6题:
Consider the MySQL Enterprise Audit plugin.On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start?()
A.Re-install the audit plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file
第7题:
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.C: \> mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?()
A.Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
B.An error message is issued because – install is not a valid option for mysqld
C.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf
D.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file
第8题:
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?()
A.FORCE_PLUS_PERMANENT is not valid for the audit-log option
B.The audit_log.so library does not exist
C.The audit_log.so library is in a location that is different from that defined by the plugin_dir option
D.The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
E.The audit log file does not exist in which to write audit events
F.The audit_log.so library is not an executable file
第9题:
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql> CALL prepare_db ( ); Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql> SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?()
第10题:
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?()