__________ rules used to limit the volume of log information that has to be…
2014
__________ rules used to limit the volume of log information that has to be handled and processed in the event of system failure involving the loss of volatile information.
- A.
Write-ahead log
- B.
Check-pointing
- C.
Log buffer
- D.
Thomas
Attempted by 181 students.
Show answer & explanation
Correct answer: B
A checkpoint is a mechanism used in database recovery systems to reduce the amount of log information that must be processed after a system failure, especially when volatile information (like main memory content) is lost.
During a checkpoint:
The system writes all modified (dirty) pages from memory to disk.
A special log record called a checkpoint record is written.
This creates a known, consistent state on disk.