1Z0-062 · Question #358
Which three statements are true about Oracle checkpoint processing? (Choose three.)
The correct answer is B. Database Writer (DBWn) processes write checkpoint information to datafile headers and the C. It reduces the recovery time from instance failures E. Thread checkpoints ensure that all dirty buffers are written to data files during a normal shutdown. Oracle checkpoint processing ensures data durability on disk, reduces instance recovery time, and involves dedicated background processes for writing dirty buffers and updating control files.
Question
Which three statements are true about Oracle checkpoint processing? (Choose three.)
Options
- AFrequent thread checkpoints can degrade database performance
- BDatabase Writer (DBWn) processes write checkpoint information to datafile headers and the
- CIt reduces the recovery time from instance failures
- DIncremental checkpoints write some dirty buffers to the datafiles and unwritten redo to the online
- EThread checkpoints ensure that all dirty buffers are written to data files during a normal shutdown
How the community answered
(22 responses)- A5% (1)
- B91% (20)
- D5% (1)
Why each option
Oracle checkpoint processing ensures data durability on disk, reduces instance recovery time, and involves dedicated background processes for writing dirty buffers and updating control files.
While frequent checkpoints can indeed degrade database performance by increasing I/O activity, this statement describes a potential consequence of checkpoint tuning rather than a fundamental operational aspect of checkpoint processing, and is not selected among the core truths.
The Database Writer (DBWn) processes are responsible for writing dirty blocks from the database buffer cache to the datafiles, while the Checkpoint (CKPT) process updates control files and datafile headers with checkpoint information.
Checkpoints reduce the recovery time from instance failures by ensuring that all data blocks modified up to a specific System Change Number (SCN) are written to disk, thus minimizing the amount of redo application required during recovery.
Incremental checkpoints write some dirty buffers to datafiles, but they do not write unwritten redo to the online redo logs; the Log Writer (LGWR) process is solely responsible for writing redo entries to the online redo logs.
During a normal database shutdown, a checkpoint is performed to guarantee that all dirty buffers residing in the database buffer cache are written to their respective data files, ensuring data consistency before the database is closed.
Concept tested: Oracle checkpoint processing mechanisms and purpose
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/introduction-to-the-oracle-database.html#GUID-85D7B799-C0B3-4E60-85A3-A0A620242205
Topics
Community Discussion
No community discussion yet for this question.