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 operates in NOARCHIVELOG mode and takes weekly operating-system backups after a clean database shutdown. No consistent incremental backups or logical exports are available. Which recovery outcome is supported after media failure?
Please select the best answer.
  A. Restore the complete database to the state of the latest usable consistent weekly backup.
  B. Recover an accidentally dropped table with no loss of later database changes.
  C. Restore one old damaged datafile and recover it to the current database state without archived redo.
  D. Perform database point-in-time recovery to any time after the weekly backup.

2. What is the primary responsibility of the checkpoint process, CKPT?
Please select the best answer.
  A. Write modified database blocks directly from the buffer cache to datafiles.
  B. Write transaction commit records from the redo log buffer to online redo logs.
  C. Update the control file and datafile headers with checkpoint information and signal DBWn to write blocks.
  D. Copy filled online redo log groups to archived redo log destinations.

3. What should the DBA do first after a possible media failure affects a NOARCHIVELOG database?
Please select the best answer.
  A. Assess the failure, identify which structures survived, and select the latest usable consistent recovery source.
  B. Immediately overwrite every database file with the oldest available backup.
  C. Clear every online redo log group before examining its status.
  D. Always issue SHUTDOWN ABORT, even when the instance is already stopped or can shut down cleanly.

4. Which actions correctly describe restoring RMAN datafiles to an alternate location?
Please select all the correct answers.
  A. Use SET NEWNAME in an RMAN RUN block to identify the alternate datafile destination.
  B. Use RESTORE to write the selected datafiles from backup to their new locations.
  C. Use SWITCH DATAFILE or SWITCH DATAFILE ALL to update the control file to the restored datafile locations.
  D. If control files themselves move, update the CONTROL_FILES initialization parameter as required.
  E. SWITCH DATAFILE ALL automatically relocates control files, online redo logs, archived logs, and the SPFILE.

5. When control files are restored or copied to a different location, which configuration must identify their new names before the database can mount them?
Please select the best answer.
  A. The password file
  B. The CONTROL_FILES initialization parameter in the SPFILE or PFILE
  C. The datafile headers
  D. The archived redo logs