Upgrade to Oracle Database 12c — Question 22

Which action takes place when an incremental checkpoint occurs?

Answer options

• A. The checkpoint position is advanced by the checkpoint process.
• B. Redo entries are written by the checkpoint process to the online redo log files.
• C. All dirty buffers are written to data files by the checkpoint process.
• D. The checkpoint position is written to all the data file headers and the control file by the checkpoint process.
• E. The checkpoint position is written to the control file by the checkpoint process.

Correct answer: C

Explanation

The correct answer is C because during an incremental checkpoint, all dirty buffers are indeed written to the data files to ensure data consistency. Option A is incorrect as it does not specify the writing of dirty buffers, and options B, D, and E are also incorrect as they describe other actions that do not occur specifically during an incremental checkpoint.