1z0-883 MySQL 5.6 Database Administrator - Practice Questions

Question 4

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?

Select all that apply, then click Submit answer.

○
FORCE_PLUS_PERMANENT is not valid for the audit-log option.
○
The audit_log.so library does not exist.
○
The audit_log.so library is in a location that is different from that defined by the plugin_dir option.
○
The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.
○
The audit log file does not exist in which to write audit events.
○
The audit_log.so library is not an executable file.

Reference / correct answer:

The audit_log.so library does not exist.

The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

* B C(not F): --plugin-load=plugin_list

This option tells the server to load the named plugins at startup. The option value is a semicolon-separated list of name=plugin_library pairs. Each name is the name of the plugin, and plugin_library is the name of the shared library that contains the plugin code. Each library file must be located in the directory named by the plugin_dir system variable. For example, if plugins named myplug1 and myplug2 have library files myplug1.so and myplug2.so, use this option to load them at startup:

shell> mysqld --plugin-load="myplug1=myplug1.so;myplug2=myplug2.so"

* not A, not D: To control the activation of the audit_log plugin, use this option:

--audit-log[=value]

Valid Values: ON, OFF, FORCE, FORCE_PLUS_PERMANENT

This option controls how the server loads the audit_log plugin at startup. It is available only if the audit log plugin has been previously registered with INSTALL PLUGIN or is loaded with --plugin-load.

--audit-log=FORCE_PLUS_PERMANENT tells the server to load the plugin and prevent it from being removed while the server is running.

Reference: 6.3.12.6 Audit Log Plugin Options and System Variables; 5.1.3 Server Command Options

Question 5

What are three actions performed by the mysql_secure_installation tool?

Select all that apply, then click Submit answer.

○
It prompts you to set the root user account password.
○
It checks whether file permissions are appropriate within datadir.
○
It asks to remove the test database, which is generated at installation time.
○
It can delete any anonymous accounts.
○
It verifies that all users are configuration with the longer password hash.

Question 6

Following a server crash, the automatic recovery of InnoDB fails.

How would you begin to manually repair the InnoDB tables?

Select an option, then click Submit answer.

○
Start the server with the – innodb_force_recovery option set to a non-zero value.
○
Start the server as usual, and then execute the REPAIR TABLE command.
○
Start the server as usual, and then execute the CHECK TABLE command.
○
Start the server with the – innodb_recover_options option set to FORCE.

1z0-883 – MySQL 5.6 Database Administrator