Beginner Database Management Systems
Q33 / 100

What is a database transaction log?

Correct! Well done.

Incorrect.

The correct answer is B) A record of all database changes (before and after images) used for recovery after failures

B

Correct Answer

A record of all database changes (before and after images) used for recovery after failures

Explanation

The transaction log (write-ahead log / WAL) records all changes before applying them to data files. On crash recovery, the DBMS replays committed transactions and undoes uncommitted ones using this log.

Previous All Questions Next
Progress
33/100
🗄️

Browse All Database Management Systems Questions

100 questions · beginner to advanced