Backup Options   «Prev  Next»

Recovering the Database with inactive Redo Logs - Quiz

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

1. What are the advantages of the ALTER DATABASE CLEAR LOGFILE command?
Please select all the correct answers.
  A. The command can be used to clear an online redo log file required for media recovery.
  B. The command can be used to clear the corrupt redo log file that belongs to the current group.
  C. The command can be used to clear a corrupt online redo log file even if there are only two online redo log groups.
  D. This command can be used to clear a corrupted, unarchived online redo log file and makes complete recovery unnecessary.

2. After a media failure, one of the online redo log files is damaged. Which of the following will tell you that there is no data loss?
Please select all the correct answers.
  A. The status of the damaged online redo log is inactive.
  B. The damaged online redo log is already archived.
  C. The damaged online redo log file is current.
  D. The online redo logs are mirrored in the database.