Backup Options   «Prev 

Infrequent Recovery Situations and Redo Log Maintenance - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. After a media failure is corrected, you find out the tablespace EMPLOYEE_HISTORY is corrupted. This tablespace was created two days ago and there is no backup. However, all the archived logs are available for the past 5 business days. Which of the following complete recovery methods do you use to recover the tablespace?
Please select the best answer.
  A. Recover a closed database
  B. Recover a datafile with no backup
  C. Recover an open database, initially open
  D. Recover an open database, initially closed

2. In the process of recovering a datafile with no backup, which of the following are valid steps?
Please select all the correct answers.
  A. Take the damaged datafile offline
  B. Restore the damaged datafile to a different location
  C. Recreate the damaged datafile to a different location
  D. Recover the affected datafile by applying all archived and online redo logs

3. When you issue the ALTER DATABASE CLEAR UNARCHIVED LOG FILE GROUP <group_number> command, what happens?
Please select all the correct answers.
  A. The damaged online redo log file is dropped and recreated.
  B. The offline datafiles become useless if the cleared log file is needed for recovery.
  C. Incomplete recovery of the database becomes impossible.
  D. Complete recovery of the database becomes impossible.

4. Before you finish your routine open database backup of a tablespace, a power outage occurs and the database is brought down. You try to open the database, but fail. Now your database is in the mount mode. What could you do?
Please select all the correct answers.
  A. Perform a complete database recovery
  B. Take the tablespace in the backup mode offline
  C. Issue the command ALTER TABLESPACE ...END BACKUP
  D. Issue the command ALTER DATABASE DATAFILE ... END BACKUP

5. Which of the following data dictionary views are only available after you issue the ALTER DATABASE RECOVER command?
Please select all the correct answers.
  A. V$RECOVERY_LOG
  B. V$RECOVERY_FILE_STATUS
  C. V$RECOVER_FILE
  D. V$RECOVERY_STATUS