1Z0-062 Question #220: Real Exam Question with Answer & Explanation

The correct answer is C: It advances the checkpoint position in the checkpoint queue.. Incremental checkpoints advance the checkpoint position in the checkpoint queue and record it in the control file, but do not write to data file headers.

Question

Which two actions does an incremental checkpoint perform?

Options

AIt signals CKPT to write thecheckpoint position to the data file headers.
BIt writes the checkpoint position to the data file headers.
CIt advances the checkpoint position in the checkpoint queue.
DIt writes the checkpoint position to the control file.

Explanation

Incremental checkpoints advance the checkpoint position in the checkpoint queue and record it in the control file, but do not write to data file headers.

Common mistakes.

A. Signaling CKPT to write the checkpoint position to data file headers describes what happens during a complete checkpoint, not an incremental one.
B. Writing the checkpoint position directly to data file headers is a complete checkpoint action, not an incremental checkpoint action.

Concept tested. Oracle incremental checkpoint actions and targets

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/buffer-cache-concepts.html

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice