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.
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.6/en/audit-log-plugin-installation.html
B,C
D
B,C
BC
http://dev.mysql.com/doc/refman/5.6/en/audit-log-plugin-installation.html
B, C
A: false, FORCE_PLUS_PERMANENT is a valid option
B: true, (eg on mysql-community you don’t have that file)
C: true, (eg. you have another plugin-dir)
D: false, you can load plugins via my.cnf too
E: false, the plugin creates the log file
F: false, .so don’t have to be executable