1Z0-062 Question #160: Real Exam Question with Answer & Explanation

The correct answer is B: All buffers for a checkpointed file that were modified before a specific SCN are written to disk by. Every data file has a data file checkpoint SCN, which you can view in V$DATAFILE.CHECKPOINT_CHANGE#. All changes with an SCN lower than this SCN are guaranteed to be in the file. When a level 0 incremental backup is restored, the restored data file contains the checkpoint SCN tha

Question

Which action takes place when a file checkpoint occurs?

Options

AThe checkpoint position is advanced in the checkpoint queue.
BAll buffers for a checkpointed file that were modified before a specific SCN are written to disk by
CThe Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
DThe Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

Explanation

Every data file has a data file checkpoint SCN, which you can view in V$DATAFILE.CHECKPOINT_CHANGE#. All changes with an SCN lower than this SCN are guaranteed to be in the file. When a level 0 incremental backup is restored, the restored data file contains the checkpoint SCN that it had when the level 0 was created. When a level 1 incremental backup is applied to a file, the checkpoint SCN of the file is advanced to the checkpoint SCN that the file had when the incremental level 1 backup was created. https://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV90078

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice