Backup Options   «Prev  Next»

Infrequent Recovery Situations - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. The complete recovery method--recovering a datafile with no backup--can be used in which of the following situations?
Please select the best answer.
  A. The corrupted datafiles belong to the system tablespace and have no backup, but all archived logs exist since the file was created.
  B. The corrupted datafiles have no backup and all archived logs exist since the file was created.
  C. The datafiles needing recovery have no backup and some of the archived logs since the creation of these datafiles are damaged.
  D. The damaged datafile belongs to a rollback segment tablespace and has no backup, but all archived logs exist since the datafile was created.

2. To check the backup status of all online datafiles, which data dictionary view do you use?
Please select the best answer.
  A. V$BACKUP_DATAFILE
  B. V$RECOVER_FILE
  C. V$BACKUP
  D. V$BACKUP_REDOLOG

3. Which of the following scenarios would require an incomplete recovery rather than a complete recovery?
Please select the best answer.
  A. A datafile from a temporary tablespace is lost, but all archived logs and backups are available.
  B. A datafile from a read-only tablespace is missing, but a backup is available.
  C. The database crashes due to a lost redo log file that was not multiplexed and contains uncommitted transactions.
  D. A user inadvertently dropped a tablespace, but a backup and all archived logs are available since the last backup.

Correct answers:

Your Score: 0