Multiple choice

Which of the following recovery mechanisms must ensure that the before image (BFIM) of the data item is recorded in the appropriate log entry, and that the log entry is flushed to disk before the BFIM is overwritten with the after image (AFIM) in the database on disk?

  1. Page Table

  2. Segmentation

  3. Overlays

  4. Write-ahead logging

  5. Semaphores
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is a recovery mechanism which must ensure that the before image (BFIM) of the data item is recorded in the appropriate log entry, and that the log entry is flushed to disk before the BFIM is overwritten with the after image (AFIM) in the database on disk.

Keep practicing — related questions