Which three statements are true about Oracle checkpoint processing? (Choose three.)
A. Frequent thread checkpoints can degrade database performance
B. Database Writer (DBWn) processes write checkpoint information to datafile headers and the control file
C. It reduces the recovery time from instance failures
D. Incremental checkpoints write some dirty buffers to the datafiles and unwritten redo to the online redo logs.
E. Thread checkpoints ensure that all dirty buffers are written to data files during a normal shutdown
|
Download Printable PDF. VALID exam to help you PASS. |
 |
https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#BABHFGFF
The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBWn to write blocks to disk. Checkpoint information includes the checkpoint position, SCN, location in online redo log to begin recovery, and so on. As shown in Figure 15-4, CKPT does not write data blocks to data files or redo blocks to online redo log files.
B is wrong. The checkpoint process (CKPT) is responsible for writing checkpoints to the data file headers and control file
The correct answer is ACE