RelationalDBDesign RelationalDBDesign

Backup Options   «Prev  Next»

Restoring Database - Quiz

Required data structures for restore and recovery

Select the best answer or answers for each question.
1. What are the tasks you should perform to recover a database? Please select all the correct answers.
  A. Export the data from the database into an operating system file
  B. Copy the backup files to the original file directory using the operating system COPY command
  C. Make the restored files current by issuing the RECOVER command
  D. Edit init.ora files and password files

2. What are the required data structures to restore a NOARCHIVELOG database?
Please select all the correct answers.
  A. All datafiles
  B. All online redo logs
  C. All redo logs
  D. Control files
  E. Archive redo logs

3. Why are rollback segments important to database recovery?
Please select all the correct answers.
  A. To undo any uncommitted changes applied from the redo log to the datafiles
  B. To reconstruct the lost information
  C. To make sure the data is in a consistent state
  D. To ensure that Oracle starts reading the log threads for the redo application at the correct point