2.11. Review Questions

  1. How is block change tracking enabled?

    1. With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    2. With ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

    3. With a INIT.ORA parameter change

    4. With a SPFILE parameter change

  2. What type of backup is stored in a proprietary RMAN format?

    1. Backup set

    2. Image copy

    3. Backup section

    4. Backup group

  3. What method is used to improve backup performance when creating backup sets?

    1. Multicopy

    2. Multiplecopy

    3. Multiplex

    4. Multiply

  4. Which command creates an image copy?

    1. BACKUP AS COPY

    2. BACKUP COPY

    3. COPY AS BACKUP

    4. COPY BACK

  5. Compressed backups work with which of the following commands?

    1. COPY AS BACKUP

    2. BACKUP AS COPY

    3. BACKUP

    4. COPY

  6. What ratio are compressed backups sized to?

    1. 30 percent

    2. 40 percent

    3. 70 percent

    4. 20 percent

  7. Which of the following best describes a full backup?

    1. All datafiles of a database

    2. All datafiles, archive logs, and control files

    3. All datafiles and control files

    4. All the used blocks in a datafile

  8. Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

    1. Differential incremental backup

    2. Different incremental backup

    3. Cumulative backup

    4. Cumulative incremental backup

  9. Which type of backup must be performed first with an incremental backup?

    1. Level 1

    2. Level 0

    3. Level 2

    4. Level 3

  10. Which backup option defines a user-defined name for a backup?

    1. FORMAT

    2. NAME

    3. TAG

    4. FORMAT U%

  11. What action requires the RESTORE command?

    1. Restoring a backup set

    2. Restoring an image copy

    3. Performing all RMAN recovery processes

    4. All of the above

  12. Which of the following most closely represents an image copy?

    1. Unix cp command of a file

    2. Bit-by-bit copy of a file

    3. Windows COPY command of a file

    4. All of the above

  13. Which dynamic view displays the status of block change tracking?

    1. V$BLOCK_CHANGE

    2. V$BLOCK_CHANGE_TRACKING

    3. V$BLOCKCHANGE

    4. V$BLOCK_TRACKING

  14. Which new Oracle 10g capability improves the backup efficency database of any size?

    1. Differential incremental backup

    2. Cumulative incremental backup

    3. Block change tracking

    4. Compressed backup

  15. Where are RMAN dynamic views stored?

    1. Recovery catalog database

    2. Control file of the recovery catalog database

    3. Control file of the target database

    4. Target database

  16. Which of the following can be used to monitor RMAN backups?

    1. LIST commands

    2. REPORT commands

    3. RMAN dynamic views

    4. All of the above

  17. The LIST commands are best used to identify what about RMAN?

    1. How many times the database is restored

    2. Files impacted by the CHANGE, CROSSCHECK, and DELETE commands

    3. Only data in the recovery catalog

    4. All of the above

  18. The REPORT command is best used to identify what about RMAN?

    1. Which files need a backup

    2. Unneeded backups

    3. Database physical schema

    4. If unrecoverable operations were performed on files

    5. All of the above

  19. What should be done to generate accurate information from the REPORT command?

    1. Recently performed CHANGE command

    2. Recently performed UNCATALOG command

    3. Recently performed CROSSCHECK commands

    4. RMAN repository synchronized with the control file

    5. All of the above

  20. Identify the methods used to schedule a backup job. (Choose all that apply.)

    1. A third-party GUI tool provided by the media management provider

    2. A file that is scheduled with the operating system scheduler

    3. Running the EM Maintenance utility

    4. Running RMAN from CLI

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

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