Database Logging | MCQs

Explanation

A transaction log is a history of actions executed by a "Database Management System" (DBMS) to guarantee "ACID" properties over crashes or hardware failures.

Physically, a log is a file listing changes to the database, stored in a stable storage format.

Explanation

• The `--log-bin-index` option is used to enable the binary log index file in MySQL.
• This option allows you to specify the name of the index file that stores the binary log file names.