RelationalDBDesign RelationalDBDesign

Incomplete Recovery   «Prev  Next»

Basic Concepts Incomplete Recovery[Backup] - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Incomplete recovery of an ARCHIVELOG database becomes necessary in which of the following situations?
Please select all the correct answers.
  A. Some tables are removed accidentally from the database
  B. A complete recovery failed because some of your archived logs are corrupt
  C. The database cannot be started because the parameter file is damaged
  D. The current redo log is accidentally dropped

2. Time-based recovery is appropriate for which of the following situations?
Please select the best answer.
  A. Some of the archived logs needed for recovery are lost
  B. A database needs to be built to a certain point-in-time with a different structure from the current one
  C. The current redo log is corrupt and it is impossible to find when it was damaged
  D. The approximate time is known when some bad data was committed to the database

3. Which of the following is true about an incomplete recovery?
Please select all the correct answers.
  A. The incomplete recovery can only be applied to an ARCHIVELOG database.
  B. All the datafiles from the backup must be restored for an incomplete recovery to be successful.
  C. The incomplete recovery is performed while the database is started with the open option.
  D. A whole database backup must be performed before and after each incomplete recovery.