Which action takes place when a file checkpoint occurs?

Which action takes place when a file checkpoint occurs?

Question:

Which action takes place when a file checkpoint occurs?

Options:

The checkpoint position is advanced in the checkpoint queue.

All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.

The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.

The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

Correct Answer

The Correct Answer for this Question is

All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *