Which three statements are true about checkpointing? (Choose three.)
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.
Explanation:
https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT89043
I prefer to choose B,C and D.
E is not correct.
The checkpoint process (CKPT) is responsible for writing checkpoints to the data file headers and control file.
agree. E is performed by CKPT itself.