Review Questions
1. The RMAN CROSSCHECK command requires the use of which of the following?
A. Recovery catalog
B. RMAN repository only
C. Standard channel allocation
D. Allocated channel for restore
Answer: A
The CROSSCHECK command requires the use of a recovery catalog. This is the backup information that must be checked with the recovery catalog to compare to the tape or disk media where the actual backups are stored.
Chapter: 12
2. What type of channel gets allocated for the CROSSCHECK command?
A. c1
B. t1
C. MAINTENANCE
D. Only sbt_tape
Answer: C
The channel that gets allocated for CROSSCHECK command is a special channel for maintenance only. c1 and t1 are simply names of the channel devices.
Chapter: 12
3. The CROSSCHECK command can only be performed on what type of backups? (Choose all that apply.)
A. Backup pieces only
B. Backup sets
C. Copies
D. Backup sets only
Answer: B, C
The CROSSCHECK command can perform both backup sets and copies.
Chapter: 12
4. Which command is used to remove backup sets and copies from the recovery catalog?
A. REMOVE
B. UNAVAILBLE
C. DELETE
D. MARK UNSUABLE
Answer: B
The DELETE command removes backup sets and copies for the catalog.
Chapter: 12
5. What channel type is required for using the DELETE command?
A. DELETE
B. c1
C. MAINTENANCE
D. t1
Answer: A
The allocate channel for delete is necessary when using the DELETE command. c1 and t1 are names of the channel devices.
Chapter: 12
6. The CHANGE AVAILABILITY command can be used on what type of backups? (Choose all that apply.)
A. Copies
B. User-managed backups
C. Backup sets
D. Cataloged backups
Answer: A, C, D
The CHANGE AVAILABILITY command can be used on backup sets, copies, and cataloged backups that are file copies.
Chapter: 12
7. What is the status of an unavailable backup?
A. Unavailable
B. Deleted
C. U
D. UA
Answer: C
The status of unavailable is seen in the list command output and is U.
Chapter: 12
8. The RMAN retention policy is known as what?
A. Command
B. Report
C. List
D. CONFIGURATION parameter
Answer: D
The retention policy is a parameter known as a CONFIGURATION parameter. There are many other configuration parameters.
Chapter: 12
9. The retention policy can be bypassed by what command?
A. EXTEND
B. KEEP
C. EXEMPT
D. UNLIMITED
Answer: B
The RMAN KEEP command causes backups to bypass or outlast a retention policy.
Chapter: 12
10. What is the term for recording non-RMAN backup in the RMAN repository?
A. OS file copies
B. Backup sets
C. Backup pieces
D. Catalog backups
Answer: D
A catalog backup is a file that is backed up for an OS or a user-managed backup.
Chapter: 12
11. When a backup set is made unavailable, what commands must be used?
A. CHANGE and UNAVAILABLE
B. SET and UNAVAILABLE
C. MAKE and UNAVALIBLE
D. CHANGE and REMOVE
Answer: A
The command to make a backup set unavailable is CHANGE BACKUPSET <backupset_number> UNAVAILBLE.
Chapter: 12
12. In order to delete a backup from disk, you must perform which of the following commands?
A. ALLOCATE CHANNEL FOR REMOVE TYPE DISK
B. ALLOCATE CHANNEL FOR DELETE TYPE DISK
C. ALLOCATE CHANNEL FOR UNAVAILABLE TYPE DISK
D. ALLOCATE CHANNEL TO DELETE TYPE DISK
Answer: B
The ALLOCATE CHANNEL FOR DELETE TYPE DISK command will allocate what is necessary before you can delete a backup within RMAN.
Chapter: 12
13. Which of the following commands will set the retention policy for 7 days within RMAN?
A. CONFIGURE RETENTION POLICY TO RECOVERY PERIOD OF 7 DAYS;
B. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
C. CONFIGURE RETENTION POLICY TO RECOVERY TIME OF 7 DAYS;
D. CONFIGURE RETENTION POLICY TO RECOVERY TIMEFRAME OF 7 DAYS;
Answer: B
The correct command is CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS. The other options are invalid syntax for the configuration parameters.
Chapter: 12
14. Which of the following commands will display the retention policy?
A. show retention plan
B. display all
C. show all
D. display retention plan
Answer: C
The show all command will display all configuration parameters in RMAN. One of these configuration parameters is the retention policy.
Chapter: 12
15. Which of the following commands will allow you to identify if the availability of a data file copy has changed?
A. LIST COPY OF DATABASE AVAILABILITY
B. LIST COPY OF DATABASE
C. LIST COPY OF AVAILABILITY
D. LIST BACKUP OF AVAILBILITY
Answer: B
The LIST COPY OF DATABASE command will show status of A for available and U for unavailable.
Chapter: 12
1. The RMAN CROSSCHECK command requires the use of which of the following?
A. Recovery catalog
B. RMAN repository only
C. Standard channel allocation
D. Allocated channel for restore
Answer: A
The CROSSCHECK command requires the use of a recovery catalog. This is the backup information that must be checked with the recovery catalog to compare to the tape or disk media where the actual backups are stored.
Chapter: 12
2. What type of channel gets allocated for the CROSSCHECK command?
A. c1
B. t1
C. MAINTENANCE
D. Only sbt_tape
Answer: C
The channel that gets allocated for CROSSCHECK command is a special channel for maintenance only. c1 and t1 are simply names of the channel devices.
Chapter: 12
3. The CROSSCHECK command can only be performed on what type of backups? (Choose all that apply.)
A. Backup pieces only
B. Backup sets
C. Copies
D. Backup sets only
Answer: B, C
The CROSSCHECK command can perform both backup sets and copies.
Chapter: 12
4. Which command is used to remove backup sets and copies from the recovery catalog?
A. REMOVE
B. UNAVAILBLE
C. DELETE
D. MARK UNSUABLE
Answer: B
The DELETE command removes backup sets and copies for the catalog.
Chapter: 12
5. What channel type is required for using the DELETE command?
A. DELETE
B. c1
C. MAINTENANCE
D. t1
Answer: A
The allocate channel for delete is necessary when using the DELETE command. c1 and t1 are names of the channel devices.
Chapter: 12
6. The CHANGE AVAILABILITY command can be used on what type of backups? (Choose all that apply.)
A. Copies
B. User-managed backups
C. Backup sets
D. Cataloged backups
Answer: A, C, D
The CHANGE AVAILABILITY command can be used on backup sets, copies, and cataloged backups that are file copies.
Chapter: 12
7. What is the status of an unavailable backup?
A. Unavailable
B. Deleted
C. U
D. UA
Answer: C
The status of unavailable is seen in the list command output and is U.
Chapter: 12
8. The RMAN retention policy is known as what?
A. Command
B. Report
C. List
D. CONFIGURATION parameter
Answer: D
The retention policy is a parameter known as a CONFIGURATION parameter. There are many other configuration parameters.
Chapter: 12
9. The retention policy can be bypassed by what command?
A. EXTEND
B. KEEP
C. EXEMPT
D. UNLIMITED
Answer: B
The RMAN KEEP command causes backups to bypass or outlast a retention policy.
Chapter: 12
10. What is the term for recording non-RMAN backup in the RMAN repository?
A. OS file copies
B. Backup sets
C. Backup pieces
D. Catalog backups
Answer: D
A catalog backup is a file that is backed up for an OS or a user-managed backup.
Chapter: 12
11. When a backup set is made unavailable, what commands must be used?
A. CHANGE and UNAVAILABLE
B. SET and UNAVAILABLE
C. MAKE and UNAVALIBLE
D. CHANGE and REMOVE
Answer: A
The command to make a backup set unavailable is CHANGE BACKUPSET <backupset_number> UNAVAILBLE.
Chapter: 12
12. In order to delete a backup from disk, you must perform which of the following commands?
A. ALLOCATE CHANNEL FOR REMOVE TYPE DISK
B. ALLOCATE CHANNEL FOR DELETE TYPE DISK
C. ALLOCATE CHANNEL FOR UNAVAILABLE TYPE DISK
D. ALLOCATE CHANNEL TO DELETE TYPE DISK
Answer: B
The ALLOCATE CHANNEL FOR DELETE TYPE DISK command will allocate what is necessary before you can delete a backup within RMAN.
Chapter: 12
13. Which of the following commands will set the retention policy for 7 days within RMAN?
A. CONFIGURE RETENTION POLICY TO RECOVERY PERIOD OF 7 DAYS;
B. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
C. CONFIGURE RETENTION POLICY TO RECOVERY TIME OF 7 DAYS;
D. CONFIGURE RETENTION POLICY TO RECOVERY TIMEFRAME OF 7 DAYS;
Answer: B
The correct command is CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS. The other options are invalid syntax for the configuration parameters.
Chapter: 12
14. Which of the following commands will display the retention policy?
A. show retention plan
B. display all
C. show all
D. display retention plan
Answer: C
The show all command will display all configuration parameters in RMAN. One of these configuration parameters is the retention policy.
Chapter: 12
15. Which of the following commands will allow you to identify if the availability of a data file copy has changed?
A. LIST COPY OF DATABASE AVAILABILITY
B. LIST COPY OF DATABASE
C. LIST COPY OF AVAILABILITY
D. LIST BACKUP OF AVAILBILITY
Answer: B
The LIST COPY OF DATABASE command will show status of A for available and U for unavailable.
Chapter: 12
