What privileges must be granted to allow an account to create the recovery catalog? (Choose two.)
RECOVERY_CATALOG_OWNER
DBA
RESOURCE
SELECT ANY DICTIONARY TABLE
What are the types of devices that channel allocation can utilize? (Choose all that apply.)
TYPE DISK
DISK TYPE
TYPE SBT_TAPE
TYPE FLASH_AREA
Which command configures a device so that channel allocation is automatically available during backup, restore, or delete?
CONFIGURE DEVICE TYPE TO DISK
CONFIGURE CHANNEL DEVICE TYPE DISK
CHANNEL DEVICE TYPE DISK CONFIGURE
CONFIGURE DEVICE CHANNEL TYPE DISK
What is the name of the API that interfaces RMAN with different tape devices?
Media Library Interface
Media Manager Library Interface
Management Media Interface
Media Management Layer
What backup capability is not supported with RMAN?
Password file backups
Closed database backups
Control file backups
Open database backups
What are the database connection types available with RMAN? (Choose all that apply.)
Target database
Recovery catalog
Third-party database
Auxiliary database
What is the main purpose of channel control options or commands?
To control channel access options
To control the operating system resources RMAN uses when performing RMAN operations
To control manual channel allocation
To control automatic channel allocation
The FORMAT command within the RMAN utility performs what function?
It provides the capability for unique identification.
It provides the capability to recreate channel devices.
It provides the capability to rebuild channel devices.
It provides the capability to rebuild disk devices.
What command displays the settings for automatic channel setup?
SHOW CONFIGURATION
SHOW CHANNEL
SHOW ALL
SHOW DEVICE
Which new 10g feature allows Oracle RMAN to store larger databases?
The COMPRESSED BACKUPSET command
Block change tracking
The flash recovery area
Automated tablespace point-in-time recovery (TSPITR)
Which new 10g feature allows Oracle RMAN to back up larger databases more efficiently?
The COMPRESSED BACKUPSET command
The Oracle Flashback Database
Block change tracking
Automated tablespace point-in-time recovery (TSPITR)
The BACKUP command is different from image copies in what way?
A backup set is stored in proprietary format using the BACKUP command.
A backup set can be compressed using the BACKUP command.
The RESTORE command must be used during recovery.
All of the above
Which RMAN components are not required to utilize Recovery Manager? (Choose all that apply.)
Media management layer (MML)
Command line interface (CLI)
Recovery catalog
Enterprise Manager (EM)
What do you call the RMAN information stored in the control files that is written over when necessary?
Writeable information
Non-reusable information
Circular reuse records
Non-circular reuse
In order to perform parallelization of backup and restore operations, you would need at least what set up? (Choose all that apply.)
One channel allocated
Multiple channels allocated
PARALLISM configured to 1
PARALLISM configured to 2
After database login to Enterprise Manager, what is required in order to perform most backup and recovery tasks? (Choose all that apply.)
System database account
Sys database account
Oracle Unix operating system account
Administrator Windows operating system account
Which of the following statements is true about RMAN persistent settings?
Persistent settings can control device type.
Persistent settings can control backup type.
Persistent settings can control channel device.
All of the above
Where are RMAN persistent settings stored? (Choose all that apply.)
Target database catalog
Recovery catalog database
Control file
Parameter file
What feature is not a new feature of Oracle 10g RMAN?
User error recovery with flashback
Automated tablespace point-in-time recovery (TSPITR)
Compressing backups by only backing up changed blocks
Compressing the backup sets regardless of whether blocks in the datafiles are mainly used