A point of synchronization between the database and the transaction log is called a(n)________.
A) before-image
B) after-image
C) recovery
D) checkpoint
E) None of the above

Question

Quizplus · Accepted Answer

A checkpoint is a point of synchronization between the database and the transaction log where all the data modifications up to that point have been written to disk. This ensures that in case of a system failure, the database can recover to a consistent state by using the checkpoint to roll forward or roll back any transactions that were not completely written to disk. A before-image is a copy of a database page before it is modified, while an after-image is a copy of a database page after it is modified. Recovery refers to the process of restoring a database to a consistent state after a failure.

A Point of Synchronization Between the Database and the Transaction