RelationalDBDesign RelationalDBDesign


Backup Options   «Prev 

Database Recovery Scenario - Quiz

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

1. A site has no archive logging and performs no exports, but performs weekly operating system backups with the database shut down. Choose the recovery scenario that will work in this situation.
Please select the best answer.
  A. Restore the database to the date and time of the last backup
  B. Recover an accidentally dropped table with no other data loss
  C. Recover a damaged datafile with no loss of other data
  D. Perform point-in-time recovery

2. The purpose of the checkpoint process CKPT is to:
Please select the best answer.
  A. Trigger a checkpoint
  B. Reduce the workload on the log writer (LGWR) process
  C. Write a transaction commit entry
  D. Update datafile and control file log sequence numbers

3. What is the first step to take to recover a NOARCHIVELOG database?
Please select the best answer.
  A. Update the control file
  B. Replace damaged or lost files
  C. Make a backup
  D. SHUTDOWN ABORT

4. When you restore files to a different location, what do you need to do to the control files?
Please select all the correct answers.
  A. Update the new file location of all the redo log files
  B. Update the new file location of all the control files
  C. Update the new file location of all the archive log files
  D. Update the new file location of all the datafiles
  E. Update the new file location of the init.ora

5. When your control file is restored to a different location, what must you do in order to open your database?
Please select the best answer.
  A. Edit your password file with the new location of the control file
  B. Edit your parameter file with the new location of the control file
  C. Update the new location of your control file in the database
  D. Update the new location of your control file in the archive logs