Oracle Database 12c: Installation and Administration — Question 171

Which three statements are true about checkpointing? (Choose three.)

Answer options

• A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
• B. It ensures that all dirty buffers are written to data files during consistent shutdown.
• C. It reduces the time required for recovery in case of an instance failure.
• D. Frequent thread checkpoints can degrade database performance.
• E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.

Correct answer: B, C, D

Explanation

Option B is correct because checkpointing ensures that all dirty buffers are flushed to the data files during a consistent shutdown. Option C is accurate as checkpointing helps reduce recovery time after an instance failure by maintaining a stable state. Option D is also true since frequent checkpoints can lead to performance degradation due to increased I/O operations. Options A and E are incorrect as they describe processes that do not directly pertain to the specific functions of checkpointing.