Backup Recovery   «Prev  Next»

Oracle 26ai RMAN Backup and Recovery - Quiz

Six questions, one point each. Select one answer for questions 1, 2, 4, 5 and 6; select exactly two for question 3. Multiple-answer credit requires every correct choice and no extra choices.
1. Which statement correctly describes the target database control file?
Select one answer.
  A. It is another copy of the initialization parameter file.
  B. It stores the full contents of every RMAN backup piece.
  C. It records database structure and RMAN repository metadata needed for backup and recovery.
  D. It is optional whenever a recovery catalog is available.

2. What does CHARACTER SET in CREATE CONTROLFILE do?
Select one answer.
  A. Converts all application data to a new database character set.
  B. Changes the national character set of every PDB.
  C. Replaces the need to recover restored datafiles.
  D. Reconstructs character-set metadata; it must match the database character set for tablespace recovery.

3. Which TWO statements correctly describe complete RMAN media recovery?
Select exactly two answers.
  A. RESTORE retrieves database files from backups.
  B. A successful RESTORE always makes RECOVER unnecessary.
  C. RECOVER applies the changes needed to bring restored files to the recovery target.
  D. OPEN RESETLOGS is mandatory after every application-tablespace recovery.

4. What does an RMAN level 1 incremental backup capture?
Select one answer.
  A. Only entire tables whose names changed.
  B. Eligible data blocks changed since the applicable incremental baseline.
  C. Only initialization parameter changes.
  D. Every block in every datafile, regardless of earlier backups.

5. During ordinary RMAN catalog resynchronization, where does RMAN obtain changed target-database metadata?
Select one answer.
  A. From the target control file, using a consistent snapshot when needed.
  B. From the SQL*Plus command history only.
  C. From every application table by exporting its rows.
  D. From file names alone, without consulting a repository.

6. Which recovery-catalog design best avoids coupling its availability to the protected target?
Select one answer.
  A. Keep the only catalog inside the protected target and omit separate backups.
  B. Place it in a separate database, protect it independently, and plan access during target failure.
  C. Treat the catalog as a replacement for all backup storage.
  D. Store catalog credentials in public lesson scripts.