nerdexam
Oracle

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.

Managing the Database Instance

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)
  • A
    6% (2)
  • B
    9% (3)
  • C
    86% (30)

Why each option

Checkpoints ensure dirty buffers are regularly written to disk, initiate instance recovery after a crash, and consequently reduce recovery time.

AThey ensure that uncommitted transactions are rolled back in case of an instance failure.

Redo and undo segments, rather than checkpoints directly, are primarily used to ensure transaction consistency and roll back uncommitted transactions during recovery.

BThey ensure that all the dirty buffers are written to disk during a normal shutdown.

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.

CThey ensure that instance recovery starts in the event of an instance failure.Correct

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.

DThey ensure that dirty buffers in the buffer cache are written to disk regularly.Correct

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.

EThey reduce the time required for recovery in case of an instance failure.Correct

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

#checkpoints#instance recovery#dirty buffers#redo logs

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice