Recovery with Archiving  «Prev 

Complete Database Recovery - Quiz

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

1. You are switching a database to ARCHIVELOG mode. Which puts the steps in the correct sequence? Please select the best answer.
  A. STARTUP MOUNT, ALTER DATABASE ARCHIVELOG, ALTER DATABASE OPEN, SHUTDOWN, make backup
  B. SHUTDOWN, make backup, STARTUP MOUNT, ALTER DATABASE ARCHIVELOG, ALTER DATABASE OPEN
  C. STARTUP, ALTER DATABASE ARCHIVELOG, SHUTDOWN, make backup
  D. SHUTDOWN, STARTUP MOUNT, ALTER DATABASE ARCHIVELOG, make backup, ALTER DATABASE OPEN

2. Read the following situation and then select the best answer. The system tablespace is contained in one datafile and the datafile becomes corrupt while the database is in ARCHIVELOG mode. A valid online backup of the entire database, including system tablespace datafile, was completed last night. Which is the most appropriate action to take to recover the datafile to the time of corruption?
Please select the best answer.
  A. Restore the datafile from backup and apply all archive logs
  B. Use the ALTER DATABASE ARCHIVELOG command
  C. Restore the entire database from last night's complete backup
  D. Perform a point-in-time recovery

3. What files need to be restored in order to make a complete recovery?
Please select the best answer.
  A. All the datafiles, control files, and the parameter file
  B. All the online redo log files
  C. Only lost or damaged datafiles
  D. Only the archived log files

4. When you perform an open database recovery, what must you do before restoring the damaged or lost datafiles?
Please select the best answer.
  A. Shutdown the database by issuing the SHUTDOWN ABORT command
  B. Take the damaged or lost datafile or tablespace offline
  C. Make sure the damaged or lost datafile or tablespace is online
  D. Bring the datafile or tablespace online

Correct answers:

Your Score: 0