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

The correct answer is 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. E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers. https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT89043

Managing the Database Instance

Question

Options

AIt prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the
BIt ensures that all dirty buffers are written to data files during consistent shutdown.
CIt reduces the time required for recovery in case of an instance failure.
DFrequent thread checkpoints can degrade database performance.
EIt prompts the Database Writer (DBWn) process to write checkpoint information into data file headers

How the community answered

(32 responses)

A
3% (1)
B
94% (30)
D
3% (1)

Explanation

https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT89043

Topics

#checkpoint#recovery#DBWn process#data files

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice