Computer Hacking Forensic Investigator (CHFI v10) — Question 342

Which MySQL log file contains information on server start and stop?

Answer options

• A. Slow query log file
• B. General query log file
• C. Binary log
• D. Error log file

Correct answer: D

Explanation

The Error log file is where MySQL logs important events, including server starts and stops, making it the correct choice. The Slow query log file records slow SQL queries, the General query log file logs all queries, and the Binary log is used for replication and recovery, none of which track server startup and shutdown events.