Review Questions
1. The RMAN utility does not require the use of which of the following?
A. Recovery catalog
B. Server sessions
C. Allocated channel for backup
D. Allocated channel for restore
Answer: A
The recovery catalog is optional. The recovery catalog is used to store information about the backup and recovery process, in much the same way as the data dictionary stores information about the database. The other options are all required elements for RMAN to function normally.
Chapter: 13
2. What are the features supported by the recovery catalog? (Choose all that apply.)
A. Backup databases, tablespaces, data files, control files, and archived logs
B. Compressed backups
C. Scripting capabilities
D. Tests that determine whether backups can be restored
E. All of the above
Answer: E
All answers are capabilities of the RMAN utility.
Chapter: 13
3. Where is the best place to store the database housing the recovery catalog?
A. On the same server but in a different filesystem than the target database being backed up by the recovery catalog
B. On the same server and in the same filesystem as the target database that is being backed up by the recovery catalog
C. On a different server than the target database
D. None of the above
Answer: C
The recovery catalog database should be on a different server than the target database to eliminate the potential of a failure on one server affecting the backup and restore capabilities of RMAN.
Chapter: 13
4. Which privileges are required for the Recovery Manager catalog user account? (Choose all that apply.)
A. DBA privilege
B. Connect privilege
C. Resource privilege
D. RECOVERY_CATALOG_OWNER privilege
Answer: B, C, D
The DBA privilege is not required from the recovery catalog user account. This user must be able to connect to the database, create objects within the database, and have the RECOVERY_CATALOG_OWNER privilege.
Chapter: 13
5. What command can be performed only once on a target database?
A. CHANGE AVAILABILITY OF BACKUPS
B. DELETE BACKUPS
C. REGISTER THE DATABASE
D. RESYNCHRONIZING THE DATABASE
Answer: C
Registering the database can be performed only once for each database unless the database is unregistered.
Chapter: 13
6. Which of the following statements best describes the target database?
A. Any database designated for backup by RMAN
B. The database that stores the recovery catalog
C. A database not targeted to be backed up by RMAN
D. A special repository database for the RMAN utility
Answer: A
The target database is any database that is targeted for backup by the RMAN utility.
Chapter: 13
7. What type of backups can be stored in the recovery catalog of RMAN? (Choose all that apply.)
A. Non-RMAN backups based on OS commands
B. Full database backups
C. Tablespace backups
D. Control file backups
E. All of the above
Answer: E
RMAN can catalog non-RMAN backups based on OS commands as well as full database backups, tablespace backups, and control file backups.
Chapter: 13
8. Which of the following are instruments used to get information from the recovery catalog? (Choose all that apply.)
A. REPORT command
B. A query in SQL*Plus
C. LIST command
D. RETRIEVAL command
Answer: A, B, C
The RMAN utility provides the REPORT and LIST commands to generate outputs from the recovery catalog. SQL*Plus can also be used to manually query the recovery catalog in certain instances.
Chapter: 13
9. What must you do prior to running the REPORT or LIST commands?
A. Determine the log file.
B. Spool the output.
C. Connect to the target.
D. Connect to the target and recovery catalog.
Answer: D
Before running any REPORT or LIST command, you must be connected to the target database and recovery catalog.
Chapter: 13
10. What is the main difference between reports and lists?
A. Lists have more output than reports.
B. Reports have more output than lists.
C. Reports provide more detailed information than lists.
D. Lists provide more detailed information than reports.
Answer: C
The REPORT command provides more detailed information than the LIST command. The REPORT command is used to answer more "what if" or "what needs to be done" type questions than the LIST command.
Chapter: 13
11. What command stores scripts in the recovery catalog?
A. CREATE SCRIPT <SCRIPT_NAME>
B. STORE SCRIPT <SCRIPT_NAME>
C. CREATE OR REPLACE <SCRIPT_NAME>
D. Scripts cannot be stored in the recovery catalog.
Answer: A
The CREATE SCRIPT <SCRIPT_NAME> command stores the associated script in the recovery catalog. This script can then be run at a later date.
Chapter: 13
12. What are the new Oracle9i list commands? (Choose all that apply.)
A. LIST BACKUP BY FILE
B. LIST BACKUP SET
C. LIST BACKUP SUMMARY FILE
D. LIST BACKUP SUMMARY
Answer: A, D
The LIST BACKUP OF FILE and LIST BACKUP SUMMARY commands are both new list commands in Oracle9i.
Chapter: 13
13. If you add a new data file to a database, what should you do to the incarnation of that database in the recovery catalog?
A. Execute a reset.
B. Execute a resync.
C. Execute a register.
D. Execute a report.
Answer: B
A resync command should be run if the physical components of the target database change.
Chapter: 13
14. The code below is intended to launch a stored RMAN script. Find the line with the incorrect syntax.
run {
execute
program
complete_bac; }
A. The first line
B. The second line
C. The third line
D. The fourth line
Answer: C
The incorrect syntax is program. The correct syntax should be as follows:
run {
execute
script
complete_bac; }
Chapter: 13
15. The code below is intended to create a script that can be used to copy archived logs. Find the line with the incorrect syntax.
Create script
Arch_bac_up {
Allocate channel cl type disk;
Backup archives all;}
A. The first line
B. The second line
C. The third line
D. The fourth line
Answer: D
The incorrect syntax is BACKUP ARCHIVES ALL;}. This should be BACKUP ARCHIVELOG ALL;}.
Chapter: 13
1. The RMAN utility does not require the use of which of the following?
A. Recovery catalog
B. Server sessions
C. Allocated channel for backup
D. Allocated channel for restore
Answer: A
The recovery catalog is optional. The recovery catalog is used to store information about the backup and recovery process, in much the same way as the data dictionary stores information about the database. The other options are all required elements for RMAN to function normally.
Chapter: 13
2. What are the features supported by the recovery catalog? (Choose all that apply.)
A. Backup databases, tablespaces, data files, control files, and archived logs
B. Compressed backups
C. Scripting capabilities
D. Tests that determine whether backups can be restored
E. All of the above
Answer: E
All answers are capabilities of the RMAN utility.
Chapter: 13
3. Where is the best place to store the database housing the recovery catalog?
A. On the same server but in a different filesystem than the target database being backed up by the recovery catalog
B. On the same server and in the same filesystem as the target database that is being backed up by the recovery catalog
C. On a different server than the target database
D. None of the above
Answer: C
The recovery catalog database should be on a different server than the target database to eliminate the potential of a failure on one server affecting the backup and restore capabilities of RMAN.
Chapter: 13
4. Which privileges are required for the Recovery Manager catalog user account? (Choose all that apply.)
A. DBA privilege
B. Connect privilege
C. Resource privilege
D. RECOVERY_CATALOG_OWNER privilege
Answer: B, C, D
The DBA privilege is not required from the recovery catalog user account. This user must be able to connect to the database, create objects within the database, and have the RECOVERY_CATALOG_OWNER privilege.
Chapter: 13
5. What command can be performed only once on a target database?
A. CHANGE AVAILABILITY OF BACKUPS
B. DELETE BACKUPS
C. REGISTER THE DATABASE
D. RESYNCHRONIZING THE DATABASE
Answer: C
Registering the database can be performed only once for each database unless the database is unregistered.
Chapter: 13
6. Which of the following statements best describes the target database?
A. Any database designated for backup by RMAN
B. The database that stores the recovery catalog
C. A database not targeted to be backed up by RMAN
D. A special repository database for the RMAN utility
Answer: A
The target database is any database that is targeted for backup by the RMAN utility.
Chapter: 13
7. What type of backups can be stored in the recovery catalog of RMAN? (Choose all that apply.)
A. Non-RMAN backups based on OS commands
B. Full database backups
C. Tablespace backups
D. Control file backups
E. All of the above
Answer: E
RMAN can catalog non-RMAN backups based on OS commands as well as full database backups, tablespace backups, and control file backups.
Chapter: 13
8. Which of the following are instruments used to get information from the recovery catalog? (Choose all that apply.)
A. REPORT command
B. A query in SQL*Plus
C. LIST command
D. RETRIEVAL command
Answer: A, B, C
The RMAN utility provides the REPORT and LIST commands to generate outputs from the recovery catalog. SQL*Plus can also be used to manually query the recovery catalog in certain instances.
Chapter: 13
9. What must you do prior to running the REPORT or LIST commands?
A. Determine the log file.
B. Spool the output.
C. Connect to the target.
D. Connect to the target and recovery catalog.
Answer: D
Before running any REPORT or LIST command, you must be connected to the target database and recovery catalog.
Chapter: 13
10. What is the main difference between reports and lists?
A. Lists have more output than reports.
B. Reports have more output than lists.
C. Reports provide more detailed information than lists.
D. Lists provide more detailed information than reports.
Answer: C
The REPORT command provides more detailed information than the LIST command. The REPORT command is used to answer more "what if" or "what needs to be done" type questions than the LIST command.
Chapter: 13
11. What command stores scripts in the recovery catalog?
A. CREATE SCRIPT <SCRIPT_NAME>
B. STORE SCRIPT <SCRIPT_NAME>
C. CREATE OR REPLACE <SCRIPT_NAME>
D. Scripts cannot be stored in the recovery catalog.
Answer: A
The CREATE SCRIPT <SCRIPT_NAME> command stores the associated script in the recovery catalog. This script can then be run at a later date.
Chapter: 13
12. What are the new Oracle9i list commands? (Choose all that apply.)
A. LIST BACKUP BY FILE
B. LIST BACKUP SET
C. LIST BACKUP SUMMARY FILE
D. LIST BACKUP SUMMARY
Answer: A, D
The LIST BACKUP OF FILE and LIST BACKUP SUMMARY commands are both new list commands in Oracle9i.
Chapter: 13
13. If you add a new data file to a database, what should you do to the incarnation of that database in the recovery catalog?
A. Execute a reset.
B. Execute a resync.
C. Execute a register.
D. Execute a report.
Answer: B
A resync command should be run if the physical components of the target database change.
Chapter: 13
14. The code below is intended to launch a stored RMAN script. Find the line with the incorrect syntax.
run {
execute
program
complete_bac; }
A. The first line
B. The second line
C. The third line
D. The fourth line
Answer: C
The incorrect syntax is program. The correct syntax should be as follows:
run {
execute
script
complete_bac; }
Chapter: 13
15. The code below is intended to create a script that can be used to copy archived logs. Find the line with the incorrect syntax.
Create script
Arch_bac_up {
Allocate channel cl type disk;
Backup archives all;}
A. The first line
B. The second line
C. The third line
D. The fourth line
Answer: D
The incorrect syntax is BACKUP ARCHIVES ALL;}. This should be BACKUP ARCHIVELOG ALL;}.
Chapter: 13
