Physical Backups  «Prev  Next»

Backup Options and Methods - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following should be protected as recovery assets for a self-managed Oracle CDB operating in ARCHIVELOG mode?
Please select all the correct answers.
  A. Only the alert log, because it contains the data needed to reconstruct committed transactions.
  B. Permanent datafiles, control-file backups, and archived redo logs needed for the recovery objective.
  C. The SPFILE or PFILE used to initialize the instance.
  D. Password files, encryption keys or keystores, and recovery credentials when required by the configuration.

2. Which statements describe the normal user-managed whole-CDB backup strategy in NOARCHIVELOG mode?
Please select all the correct answers.
  A. It guarantees recovery to the instant of a media failure, including all changes made after the backup.
  B. Shut down the CDB cleanly and keep it shut down while all required files are copied.
  C. Restoring a complete, usable consistent backup generally returns the database to the state captured by that backup.
  D. Copying active read/write datafiles while the CDB remains open creates a supported whole-database backup.

3. Which SQL*Plus command identifies the SPFILE currently used by an Oracle CDB instance?
Please select the best answer.
  A. SELECT file_name FROM dba_data_files;
  B. SHOW PARAMETER spfile
  C. SELECT name FROM v$controlfile;
  D. SELECT member FROM v$logfile;

4. Which are supported RMAN whole-CDB backup approaches, assuming appropriate privileges, complete intended coverage, usable destinations, and protection of required recovery assets?
Please select all the correct answers.
  A. Back up an open ARCHIVELOG CDB and retain all redo required to recover the restored files.
  B. Back up an open NOARCHIVELOG CDB while its active read/write datafiles continue changing.
  C. Back up an ARCHIVELOG CDB while mounted after a clean shutdown.
  D. Back up a NOARCHIVELOG CDB while mounted after a clean shutdown.

5. Which provides the strongest evidence that the documented backup strategy can meet its recovery point and recovery time objectives?
Please select the best answer.
  A. Confirming that backup filenames appear in a directory listing.
  B. Running LIST BACKUP SUMMARY without examining backup contents.
  C. Running CROSSCHECK BACKUP to reconcile availability with repository records.
  D. Performing a representative isolated restore and recovery, checking the recovered data, and measuring the achieved recovery point and elapsed time.