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
第1题:
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
第2题:
YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment,thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However,youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers,soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation?()
A.DBA_AUDIT_TRAIL
B.DBA_AUDIT_SESSION
C.DBA_FGA_AUDIT_TRAIL
D.DBA_COMMON_AUDIT_TRAIL
第3题:
A. DBA_AUDIT_EXISTS
B. DBA_AUDIT_OBJECT
C. DBA_AUDIT_POLICY_COLUMNS
D. DBA_AUDIT_POLICIES
E. DBA_AUDIT_SESSION
第4题:
You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132$tail – n2 /var/lib.mysql/hostname.err2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: ‘5.6.13-enterprise-commercial-advaced‘socket:‘/tmp/mysql.sock‘ port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)Which statement is true about this scenario?()
A.The RPM installation script sets a default password of password for new installations
B.The local root user must log in with a blank password initially: mysql –u root –p
C.New security measures mean that the mysql_secure_installation script must be run first on all new installations
D.The mysql_install_bd post-installation script used – random-password
第5题:
A.apache.conf是Apache配置文件
B.httpd.conf是Apache配置文件
C.mysql.cnf是MySQL配置文件
D.php.ini是PHP配置文件