2.12. Answers to Review Questions

  1. A. Block change tracking must be enabled with ALTER DATABASE ENABLE BLOCK CHANGE TRACKING. The physical location and name of the block change tracking file must be supplied.

  2. A. The backup set is stored in a proprietary RMAN format, where only used blocks are backed up.

  3. C. Multiplexing a backup is designed to improve the performance of the backup sets by copying multiple database files at the same time. Multiplexing can be used with image copies or backup sets.

  4. A. The BACKUP AS COPY command is used to create an image copy backup.

  5. C. Compressed backups work only with backup sets, not image copies. Thus compressed backups will work only with the BACKUP command.

  6. D. Compressed backups compressed at a ratio of 5 to 1—20 percent—of the original size of a standard backup.

  7. D. A full backup is best described by backing up all the used blocks in a datafile or any database file. A full backup can be taken on one database file.

  8. A. A differential incremental backup only backs up blocks that have been modified since a backup at the same level or lower.

  9. B. A level 0 backup is the first backup that is performed when implementing an incremental backup strategy. A level 0 backup copies all the used blocks as a baseline.

  10. C. The TAG option is used to name a backup with a user-defined character string.

  11. A. The RESTORE command is required only with a backup set recovery. This is because the backup set is stored in a RMAN proprietary format.

  12. D. Image copies are similar to operating system copy commands. These equate to bit-by-bit copies of a file.

  13. B. The V$BLOCK_CHANGE_TRACKING dynamic view shows the filename, status, and size of the block change tracking file.

  14. C. Block change tracking improves the backup efficiency of large or small databases. With block change tracking, the backup time is proportional to the amount of changes that occurred in a database.

  15. D. RMAN dynamic views are stored in the target database.

  16. D. LIST, REPORT, and dynamic views all allow different types of monitoring of RMAN activities.

  17. B. The LIST commands are used to determine files impacted by the CHANGE, CROSSCHECK, and DELETE commands.

  18. E. The REPORT command is best used to identify which files need a backup, unneeded backups, database physical schema, and if unrecoverable operations were performed on files.

  19. E. The REPORT command is accurate when the control and RMAN repository are synchronized, which can be performed by the CHANGE, UNCATALOG, and CROSSCHECK commands.

  20. A, B. Third-party GUI tools provided from the media manager software and manually scripting a file incorporated with operating system scheduler are the two methods for scheduling a backup.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset