1.13. Review Questions

  1. What is the parameter that determines the capacity of the RMAN repository?

    1. CONTROLFILE_RECORD_KEEP_TIME

    2. CONTROL_FILE_KEEP_TIME

    3. CONTROL_FILE_RECORD_KEEP_TIME

    4. CONTORL_FILE_RECORD_TIME

  2. What privileges must be granted to allow an account to create the recovery catalog? (Choose two.)

    1. RECOVERY_CATALOG_OWNER

    2. DBA

    3. RESOURCE

    4. SELECT ANY DICTIONARY TABLE

  3. What are the types of devices that channel allocation can utilize? (Choose all that apply.)

    1. TYPE DISK

    2. DISK TYPE

    3. TYPE SBT_TAPE

    4. TYPE FLASH_AREA

  4. Which command configures a device so that channel allocation is automatically available during backup, restore, or delete?

    1. CONFIGURE DEVICE TYPE TO DISK

    2. CONFIGURE CHANNEL DEVICE TYPE DISK

    3. CHANNEL DEVICE TYPE DISK CONFIGURE

    4. CONFIGURE DEVICE CHANNEL TYPE DISK

  5. What is the name of the API that interfaces RMAN with different tape devices?

    1. Media Library Interface

    2. Media Manager Library Interface

    3. Management Media Interface

    4. Media Management Layer

  6. What backup capability is not supported with RMAN?

    1. Password file backups

    2. Closed database backups

    3. Control file backups

    4. Open database backups

  7. What are the database connection types available with RMAN? (Choose all that apply.)

    1. Target database

    2. Recovery catalog

    3. Third-party database

    4. Auxiliary database

  8. What is the main purpose of channel control options or commands?

    1. To control channel access options

    2. To control the operating system resources RMAN uses when performing RMAN operations

    3. To control manual channel allocation

    4. To control automatic channel allocation

  9. The FORMAT command within the RMAN utility performs what function?

    1. It provides the capability for unique identification.

    2. It provides the capability to recreate channel devices.

    3. It provides the capability to rebuild channel devices.

    4. It provides the capability to rebuild disk devices.

  10. What command displays the settings for automatic channel setup?

    1. SHOW CONFIGURATION

    2. SHOW CHANNEL

    3. SHOW ALL

    4. SHOW DEVICE

  11. Which new 10g feature allows Oracle RMAN to store larger databases?

    1. The COMPRESSED BACKUPSET command

    2. Block change tracking

    3. The flash recovery area

    4. Automated tablespace point-in-time recovery (TSPITR)

  12. Which new 10g feature allows Oracle RMAN to back up larger databases more efficiently?

    1. The COMPRESSED BACKUPSET command

    2. The Oracle Flashback Database

    3. Block change tracking

    4. Automated tablespace point-in-time recovery (TSPITR)

  13. The BACKUP command is different from image copies in what way?

    1. A backup set is stored in proprietary format using the BACKUP command.

    2. A backup set can be compressed using the BACKUP command.

    3. The RESTORE command must be used during recovery.

    4. All of the above

  14. Which RMAN components are not required to utilize Recovery Manager? (Choose all that apply.)

    1. Media management layer (MML)

    2. Command line interface (CLI)

    3. Recovery catalog

    4. Enterprise Manager (EM)

  15. What do you call the RMAN information stored in the control files that is written over when necessary?

    1. Writeable information

    2. Non-reusable information

    3. Circular reuse records

    4. Non-circular reuse

  16. In order to perform parallelization of backup and restore operations, you would need at least what set up? (Choose all that apply.)

    1. One channel allocated

    2. Multiple channels allocated

    3. PARALLISM configured to 1

    4. PARALLISM configured to 2

  17. After database login to Enterprise Manager, what is required in order to perform most backup and recovery tasks? (Choose all that apply.)

    1. System database account

    2. Sys database account

    3. Oracle Unix operating system account

    4. Administrator Windows operating system account

  18. Which of the following statements is true about RMAN persistent settings?

    1. Persistent settings can control device type.

    2. Persistent settings can control backup type.

    3. Persistent settings can control channel device.

    4. All of the above

  19. Where are RMAN persistent settings stored? (Choose all that apply.)

    1. Target database catalog

    2. Recovery catalog database

    3. Control file

    4. Parameter file

  20. What feature is not a new feature of Oracle 10g RMAN?

    1. User error recovery with flashback

    2. Automated tablespace point-in-time recovery (TSPITR)

    3. Compressing backups by only backing up changed blocks

    4. Compressing the backup sets regardless of whether blocks in the datafiles are mainly used

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

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