Backup Recovery   «Prev  Next»

Faststart Fault Recovery - Quiz

Concepts of Fast-Start Fault Recovery

Each question is worth one point. Select the best answer for each question or questions.
 

1. Identify the three features of Fast-Start Fault Recovery
Please select all the correct answers.
  A. Fast-Start on-demand roll forward
  B. Fast-Start parallel rollback
  C. Fast-Start on-demand rollback
  D. Fast-Start checkpointing

2. What are the advantages of Fast-Start Fault Recovery?
Please select all the correct answers.
  A. Faster instance recovery due to fast checkpointing and faster transactional recovery due to on-demand rollback and parallel rollback
  B. Better performance in backup due to fast checkpointing
  C. Faster replication of data due to on-demand rollback
  D. Faster replication of data due to parallel rollback

3. What is the difference between on-demand rollback and parallel rollback?
Please select all the correct answers.
  A. On-demand rollback works on the Oracle Parallel Server (OPS). Parallel rollback rolls back whenever the user wants to rollback any data and issues the command.
  B. On-demand rollback rolls back whenever the user wants to rollback any data and issues the command. Parallel rollback works on the Oracle Parallel Server (OPS).
  C. On-demand rollback occurs when a new transaction requires locking the same record that a dead transaction has locks on. Parallel rollback occurs when the number of transactions to be rolled back is large in number.
  D. Parallel rollback occurs when replication is required between two Oracle Parallel Server based databases. On-demand rollback must be requested with Oracle Corporation.

4. What is a checkpoint and what is its utility within the database world?
Please select all the correct answers.
  A. Checkpoint is a feature that checks the database at regular intervals for any form of corruption and tries to fix them using DBMS_REPAIR packages, which have been introduced within Oracle8i.
  B. Checkpoint is a feature that checks whether all the transactions are committed to the database correctly.
  C. Checkpoint is the process of replicating data across databases helping maintain multiple copies of the database using replication.
  D. The process of identifying the status of the redo log buffers and then initiating the process of writing the information to redo log files is checkpointing.

5. What is the difference between Fast-Start checkpointing and on-demand rollback?
Please select all the correct answers.
  A. Checkpointing checks whether all the transactions are committed to the database correctly and on-demand rollback rolls back whenever the user wants to rollback any data and issues the command.
  B. Checkpointing is identifying the status of dirty redo log buffers and initiating the process of writing the transactions into the redo log files. On-demand rollback rolls back only the required data blocks from a dead transaction.
  C. Checkpointing and on-demand rollback are synonymous with the process of replication, where data is checked and rolled backed to the replicated database.
  D. Checkpointing helps in checking the backup of an instance and on-demand rollback performs recovery of a database.