1Z0-062 · Question #220
Which two actions does an incremental checkpoint perform?
The correct answer is C. It advances the checkpoint position in the checkpoint queue. D. It writes the checkpoint position to the control file.. 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.
How the community answered
(19 responses)- B5% (1)
- C95% (18)
Why each option
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.
Signaling CKPT to write the checkpoint position to data file headers describes what happens during a complete checkpoint, not an incremental one.
Writing the checkpoint position directly to data file headers is a complete checkpoint action, not an incremental checkpoint action.
An incremental checkpoint advances the checkpoint position in the checkpoint queue, which tracks the lowest SCN of dirty buffers that still need to be flushed to disk by DBWR.
The control file is updated with the new checkpoint position during an incremental checkpoint so Oracle knows the correct recovery start point if an instance failure occurs.
Concept tested: Oracle incremental checkpoint actions and targets
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/buffer-cache-concepts.html
Topics
Community Discussion
No community discussion yet for this question.