1Z0-062 · Question #241
Which three statements are true about the purpose of checkpoints?
The correct answer is C. They ensure that instance recovery starts in the event of an instance failure. D. They ensure that dirty buffers in the buffer cache are written to disk regularly. E. They reduce the time required for recovery in case of an instance failure.. Checkpoints ensure dirty buffers are regularly written to disk, initiate instance recovery after a crash, and consequently reduce recovery time.
Question
Which three statements are true about the purpose of checkpoints?
Options
- AThey ensure that uncommitted transactions are rolled back in case of an instance failure.
- BThey ensure that all the dirty buffers are written to disk during a normal shutdown.
- CThey ensure that instance recovery starts in the event of an instance failure.
- DThey ensure that dirty buffers in the buffer cache are written to disk regularly.
- EThey reduce the time required for recovery in case of an instance failure.
How the community answered
(35 responses)- A6% (2)
- B9% (3)
- C86% (30)
Why each option
Checkpoints ensure dirty buffers are regularly written to disk, initiate instance recovery after a crash, and consequently reduce recovery time.
Redo and undo segments, rather than checkpoints directly, are primarily used to ensure transaction consistency and roll back uncommitted transactions during recovery.
During a normal database shutdown, all dirty buffers are written to disk, but this is a shutdown process, not the continuous, operational purpose of checkpoints.
Checkpoints mark a point in the redo stream from which instance recovery must begin if an instance failure occurs, indicating that all changes up to that point have been written to data files.
A primary purpose of checkpoints is to ensure that dirty buffers (modified data blocks not yet written to disk) in the database buffer cache are regularly written to the data files on disk.
By frequently writing dirty buffers to disk, checkpoints reduce the number of redo records that need to be applied during the roll-forward phase of instance recovery, thereby significantly decreasing recovery time.
Concept tested: Oracle database checkpoints and recovery
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/concepts/physical-storage.html#GUID-002D022C-4A2B-4ECF-9878-E73F221B6554
Topics
Community Discussion
No community discussion yet for this question.