多项选择题
A general purpose MySQL instance is configured with the following options:
—log-slow-queries
—long-query-time=,0001
—log-slow-admin-queries
—general-log
—log-bin
—binlog-format=STATEMENT
—innodb-flush-log-at-trx-commit=1
Which three statements are true（）。
A.The General Query Log records more data than the Binary Log
B.The binary Log records more data than the General Query Log
C.The Slow Query Log records more data than the General Query Log
D.The General Query Log records more data than the Slow Query Log
E.The Slow Query Log records more data than the Binary Log
F.The Binary Log records more data than the Slow Query Log
相关考题
-
单项选择题
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 -
单项选择题
What is true regarding InnoDB locking?（）
A.InnoDB uses row and table-level locks, but row locks are not escalates
B.InnoDB locks only those rows that are updated
C.InnoDB only uses row locks, not page or table-level locks
D.InnoDB row locks may be escalated to page or table-level locks
E.InnoDB uses row-level or table-level locks depending on the number of rows affected -
单项选择题
Which statement is true about the log-output variable?（）
A.It is a static variable and can be set only at MySQL server startup
B.It enables and starts the General Query Log
C.It sets the target location for the binary logs generated by the MySQL sever
D.It specifies output destinations for the slow and General Query logs
