Oracle Database 12c: Installation and Administration — Question 69

Which action takes place when a file checkpoint occurs?

Answer options

• A. The checkpoint position is advanced in the checkpoint queue.
• B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
• C. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
• D. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

Correct answer: B

Explanation

The correct answer is B because it specifically describes the process during a file checkpoint, where modified buffers are written to disk, and the SCN is documented. Option A refers to the movement in the checkpoint queue, which does not describe the checkpoint process itself. Options C and D relate to broader database writing processes but do not specifically address the actions taken during a file checkpoint.