Backup Options   «Prev  Next»

Restoring Database - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which tasks can be part of an RMAN database restore and recovery workflow?
Please select all the correct answers.
  A. Assess the failure and select a usable backup that supports the required recovery point.
  B. Use RESTORE to retrieve the required database files from RMAN backups.
  C. Use RECOVER to apply available redo or incremental backups when the recovery procedure requires it.
  D. Edit the binary password file to update the datafile locations.

2. Which components should a recovery plan account for when restoring an Oracle 26ai NOARCHIVELOG database?
Please select all the correct answers.
  A. A compatible set of all required permanent datafiles from a usable consistent backup
  B. A usable current control file or an appropriate control-file backup when current copies are lost
  C. An SPFILE or PFILE that can start the instance with the required configuration
  D. A backup copy of every online redo log group
  E. Access to the backup media and any required encryption keys, passwords, or storage credentials

3. What role does undo play during Oracle instance recovery?
Please select the best answer.
  A. It enables Oracle to roll back uncommitted transaction changes after redo has been applied.
  B. It reconstructs a lost datafile when no backup exists.
  C. It identifies the checkpoint position where redo application must begin.
  D. It creates archived redo logs from overwritten online redo logs.

4. Which procedure creates a valid consistent whole-database RMAN backup in NOARCHIVELOG mode?
Please select the best answer.
  A. Shut down with IMMEDIATE, start the database in MOUNT state, and run BACKUP DATABASE.
  B. Run SHUTDOWN ABORT, mount the database, and immediately run BACKUP DATABASE.
  C. Leave the database open and run BACKUP DATABASE PLUS ARCHIVELOG.
  D. Copy only the control files while the database remains open.

5. A media failure destroys the datafile storage, but a usable current control file survives. Which statement is correct?
Please select the best answer.
  A. The current control file may be used; restore a control file only when no suitable current copy remains or the recovery procedure requires one.
  B. An older control-file backup must always replace the surviving current control file.
  C. The control file is unnecessary because RMAN can mount the database using only the password file.
  D. The current control file must be converted into an archived redo log before restoration.