MySQL 8.0 Database Administrator — Question 3

You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

Answer options

• A. general query log
• B. audit log
• C. slow query log
• D. binary log
• E. error log

Correct answer: D

Explanation

The binary log is specifically designed to log all changes made to the database, including both data modifications and structure changes, making it the correct choice. The general query log records all queries received by the server, while the slow query log tracks queries that take too long to execute. The audit log is meant for tracking user activity, and the error log captures errors and warnings, not changes.