Oracle Database 12c: Installation and Administration — Question 72
Which two actions does an incremental checkpoint perform? (Choose two.)
Answer options
- A. It signals CKPT to write the checkpoint position to the data file headers.
- B. It writes the checkpoint position to the data file headers.
- C. It advances the checkpoint position in the checkpoint queue.
- D. It writes the checkpoint position to the control file.
Correct answer: C, D
Explanation
The correct answers are C and D because an incremental checkpoint is responsible for advancing the checkpoint position in the queue and writing that position to the control file. Options A and B are incorrect as they pertain to writing to data file headers, which is not part of the incremental checkpoint process.