Backup Recovery   «Prev  Next»

Reporting Concepts Data Dictionary Views - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which RMAN command lists repository records for backups of the database datafiles?
Please select the best answer.
  A. LIST ALL BACKUPS;
  B. BACKUP LIST;
  C. LIST BACKUP OF DATABASE;
  D. LIST DATABASE BACKUPS;

2. Which statement correctly distinguishes the RMAN LIST and REPORT commands?
Please select the best answer.
  A. REPORT displays exactly the same information as LIST, but only changes the output format.
  B. LIST displays repository records such as backups and image copies; REPORT can analyze backup requirements and obsolescence or display the database schema.
  C. LIST creates backups, while REPORT restores them.
  D. Both commands read every backup block to verify that the database can be recovered.

3. Which statement correctly describes the dynamic performance views V$BACKUP_DEVICE and V$BACKUP_SET?
Please select the best answer.
  A. Both views contain one row for every physical backup file stored on disk.
  B. V$BACKUP_DEVICE lists backup software versions, while V$BACKUP_SET lists retention policies.
  C. V$BACKUP_DEVICE describes supported backup devices, while V$BACKUP_SET displays backup set information recorded in the control file.
  D. Both views require a separate RMAN recovery catalog database.

4. Which RMAN command reports backups that are obsolete under the configured retention policy without deleting them?
Please select the best answer.
  A. REPORT OBSOLETE;
  B. DELETE OBSOLETE;
  C. LIST EXPIRED BACKUP;
  D. REPORT SCHEMA;

5. A disk backup piece was removed outside RMAN, but its repository record still shows AVAILABLE. Which RMAN command checks recorded backups and updates their availability status?
Please select the best answer.
  A. LIST BACKUP;
  B. REPORT NEED BACKUP;
  C. REPORT OBSOLETE;
  D. CROSSCHECK BACKUP;