多項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

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

單項(xiàng)選擇題

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

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

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（）。

你可能感興趣的試題

What is true regarding InnoDB locking?（）

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（）。