You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin Which database updates are logged on the master server to the binary log by default?

Question

Options

• AAll updates except to the TEMPDB database
• BAll updates except to the PERFORMANCE_SCHEMA database
• CAll updates not involving temporary tables
• DAll updates to the default database, except temporary tables
• EAll updates to all databases

• A
  3% (1)
• B
  3% (1)
• C
  14% (5)
• D
  74% (26)
• E
  6% (2)

Explanation

Option D is correct because with binlog-format=STATEMENT and no explicit binlog-do-db or binlog-ignore-db options set, MySQL logs SQL statements executed against the currently selected (default) database - and temporary tables are excluded because they are session-scoped objects not intended for replication or point-in-time recovery.

Why the distractors are wrong:

• A is a SQL Server concept - TEMPDB does not exist in MySQL.
• B is partially true (performance_schema is never logged), but it is not the primary scope rule that defines what gets logged by default.
• C is too narrow - the exclusion of temporary tables does not extend across all databases regardless of context; logging is scoped to the default database first.
• E is incorrect because not every database or object type is logged - the default database scoping and temporary table exclusions apply.

Memory tip: Think of STATEMENT-format logging as "what you USEd, minus temporaries" - MySQL logs statements run against your active (USE db_name) database, and skips ephemeral session objects like temporary tables that have no place in a persistent binary log.

No community discussion yet for this question.