Recovery with Archiving  «Prev  Next»

Oracle Database Recovery Basics - Quiz

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

1. In order to perform complete recovery up to the time of failure, you must have which of the following?
Please select all the correct answers.
  A. A valid backup containing the lost or damaged datafiles just before you set your database in NOARCHIVELOG mode
  B. All the valid backup copies of your control files and parameter files
  C. A valid backup containing the lost or damaged datafiles after the database was set in ARCHIVELOG mode
  D. All the archive logs from the last backup until the time of the instance failure

2. Several datafiles are lost and you find that they belong to the system and rollback segment tablespaces. Which method do you decide to use?
Please select the best answer.
  A. Recover a datafile with no backup
  B. Recover an open database, initially open
  C. Recover an open database, initially closed
  D. Recover a closed database

3. Which of the following recover commands can be used ONLY for a closed database recovery?
Please select all the correct answers.
  A. RECOVER [AUTOMATIC] TABLESPACE
  B. RECOVER [AUTOMATIC] DATAFILE
  C. RECOVER DATABASE
  D. RECOVER FROM ' < NEW LOCATION> ' DATABASE

4. Which of the following data dictionary views allows you to locate all archived logs required for recovery?
Please select the best answer.
  A. V$RECOVERY_FILE
  B. V$ARCHIVED_LOG
  C. V$RECOVERY_LOG
  D. V$LOG_HISTORY