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
第1题:
A.It deletes all binary log files, except ‘mysql-in.010‘
B.It deletes all binary log files up to and including ‘mysql-bin.010‘
C.It deletes all binary log files before ‘mysql-bin.010‘
D.It deletes all binary log files after ‘mysql-bin.010‘
第2题:
A.mysql_query
B.mysql_select_db
C.mysql_connect
D.mysql_fetch_array
第3题:
A.mysql_select_db
B.mysql_connect
C.mysql_query
D.mysql_fetch_field
第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.mysql_fetch_row
B.mysql_select_db
C.mysql_query
D.mysql_connect
第6题:
【单选题】下面哪个命令组合能够打开mysql数据库监视窗口
A.mysqld-nt
B.e: cd mysql cd bin Mysql -u root
C.use book
D.start