RelationalDBDesign RelationalDBDesign


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 of the following is the correct syntax for generating a database backup list?
Please select all the correct answers.
  A. LIST ALL BACKUPS;
  B. BACKUP LIST;
  C. LIST BACKUP OF DATABASE;
  D. LIST DATABASE BACKUPS;

2. What is the difference between LIST and REPORT commands?
Please select all the correct answers.
  A. The LIST command provides a list of database backups, while the REPORT command displays the same information in a tabular format.
  B. The LIST command displays information about all database backups and image copies, whereas the REPORT command performs complex analysis.
  C. The REPORT command displays information about recovery of a database, while the LIST command provides information about backups of a database.
  D. The LIST and REPORT commands are not available within Oracle8i.

3. What is the difference between V$BACKUP_DEVICE and V$BACKUP_SET performance views?
Please select all the correct answers.
  A. Both data dictionary views provide information about database backups.
  B. V$BACKUP_DEVICE has data on the different software utilities available for database backups, while V$BACKUP_SET has information on the different formats of maintaining backup sets.
  C. V$BACKUP_DEVICE has information on supported backup devices, while V$BACKUP_SET displays backup set information from the control file.
  D. Oracle8i does not support these views.