RelationalDBDesign RelationalDBDesign


Backup Options   «Prev  Next»

Recovering a NOARCHIVELOG Database - Quiz

Select the best answer or answers for each question.
 

1. Recovering a NOARCHIVELOG database allows you to recover the database:
Please select the best answer.
  A. To the point in time of the DBA's choice
  B. To the point in time when media failure occurs
  C. To the point in time when the last backup was made
  D. To the point in time before the data was lost

2. What are the disadvantages of recovering a NOARCHIVELOG database?
Please select all the correct answers.
  A. It is very time consuming.
  B. You have to create a complex script to perform the procedure.
  C. You have to inform users to reapply the data since the last backup.
  D. It is necessary to restore all the files even if only one file is corrupted.

3. When you start to recover a NOARCHIVELOG database, you have to shut down the database properly. What shutdown option can be used?
Please select the best answer.
  A. SHUTDOWN IMMEDIATE
  B. SHUTDOWN RESTRICTED
  C. SHUTDOWN ABORT
  D. SHUTDOWN NORMAL