Oracle
1Z0-883 · Question #26
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…
The correct answer is A. The General Query Log records more data than the Binary 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. See the full explanation below for the reasoning.
Question
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?
Options
- AThe General Query Log records more data than the Binary Log.
- BThe binary Log records more data than the General Query Log.
- CThe Slow Query Log records more data than the General Query Log.
- DThe General Query Log records more data than the Slow Query Log.
- EThe Slow Query Log records more data than the Binary Log.
- FThe Binary Log records more data than the Slow Query Log.
How the community answered
(49 responses)- A80% (39)
- B6% (3)
- C4% (2)
- F10% (5)
Community Discussion
No community discussion yet for this question.