OCP Oracle 10g Admin II - Ch 2: Using Recovery Manager

Chapter 2 - Using Recovery Manager
Review Questions

1. How is block change tracking enabled?
A. With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B. With ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
C. With a INIT.ORA parameter change
D. With a SPFILE parameter change
---
Ans: A.
Block change tracking must be enabled with ALTER DATABASE ENABLE BLOCK CHANGE TRACKING. The physical location and name of the block change tracking file must be supplied.

2. What type of backup is stored in a proprietary RMAN format?
A. Backup set
B. Image copy
C. Backup section
D. Backup group
----
Ans: A.
The backup set is stored in a proprietary RMAN format, where only used blocks are backed up.

3. What method is used to improve backup performance when creating backup sets?
A. Multicopy
B. Multiplecopy
C. Multiplex
D. Multiply
---
Ans: C.
Multiplexing a backup is designed to improve the performance of the backup sets by copying multiple database files at the same time. Multiplexing can be used with image copies or backup sets.

4. Which command creates an image copy?
A. BACKUP AS COPY
B. BACKUP COPY
C. COPY AS BACKUP
D. COPY BACK
----
Ans: A.
The BACKUP AS COPY command is used to create an image copy backup.


5. Compressed backups work with which of the following commands?
A. COPY AS BACKUP
B. BACKUP AS COPY
C. BACKUP
D. COPY
-----
Ans: C.
Compressed backups work only with backup sets, not image copies. Thus compressed backups will work only with the BACKUP command.

6. What ratio are compressed backups sized to?
A. 30 percent
B. 40 percent
C. 70 percent
D. 20 percent
---
Ans: D.
Compressed backups compressed at a ratio of 5 to 1 - 20 percent - of the original
size of a standard backup.


7. Which of the following best describes a full backup?
A. All datafiles of a database
B. All datafiles, archive logs, and control files
C. All datafiles and control files
D. All the used blocks in a datafile
---
Ans: D.
A full backup is best described by backing up all the used blocks in a datafile or
any database file. A full backup can be taken on one database file.


8. Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?
A. Differential incremental backup
B. Different incremental backup
C. Cumulative backup
D. Cumulative incremental backup
----
Ans: A.
A differential incremental backup only backs up blocks that have been modified
since a backup at the same level or lower.

9. Which type of backup must be performed first with an incremental backup?
A. Level 1
B. Level 0
C. Level 2
D. Level 3
----
Ans: B.
A level 0 backup is the first backup that is performed when implementing an
incremental backup strategy. A level 0 backup copies all the used blocks as a
baseline.


10. Which backup option defines a user-defined name for a backup?
A. FORMAT
B. NAME
C. TAG
D. FORMAT U%
----
Ans: C.
The TAG option is used to name a backup with a user-defined character string.

11. What action requires the RESTORE command?
A. Restoring a backup set
B. Restoring an image copy
C. Performing all RMAN recovery processes
D. All of the above
---
Ans: A.
The RESTORE command is required only with a backup set recovery. This is
because the backup set is stored in a RMAN proprietary format.

12. Which of the following most closely represents an image copy?
A. Unix cp command of a file
B. Bit-by-bit copy of a file
C. Windows COPY command of a file
D. All of the above
---
Ans: D.
Image copies are similar to operating system copy commands. These equate to bitby-
bit copies of a file.

13. Which dynamic view displays the status of block change tracking?
A. V$BLOCK_CHANGE
B. V$BLOCK_CHANGE_TRACKING
C. V$BLOCKCHANGE
D. V$BLOCK_TRACKING
---
Ans: B.
The V$BLOCK_CHANGE_TRACKING dynamic view shows the filename, status, and size of the block change tracking file.

14. Which new Oracle 10g capability improves the backup efficency database of any size?
A. Differential incremental backup
B. Cumulative incremental backup
C. Block change tracking
D. Compressed backup
---
Ans: C.
Block change tracking improves the backup efficiency of large or small databases.
With block change tracking, the backup time is proportional to the amount of
changes that occurred in a database.

15. Where are RMAN dynamic views stored?
A. Recovery catalog database
B. Control file of the recovery catalog database
C. Control file of the target database
D. Target database
---
Ans: D.
RMAN dynamic views are stored in the target database.

16. Which of the following can be used to monitor RMAN backups?
A. LIST commands
B. REPORT commands
C. RMAN dynamic views
D. All of the above
---
Ans: D.
LIST, REPORT, and dynamic views all allow different types of monitoring of RMAN activities.

17. The LIST commands are best used to identify what about RMAN?
A. How many times the database is restored
B. Files impacted by the CHANGE, CROSSCHECK, and DELETE commands
C. Only data in the recovery catalog
D. All of the above
----
Ans: B.
The LIST commands are used to determine files impacted by the CHANGE,
CROSSCHECK, and DELETE commands.

18. The REPORT command is best used to identify what about RMAN?
A. Which files need a backup
B. Unneeded backups
C. Database physical schema
D. If unrecoverable operations were performed on files
E. All of the above
---
Ans: E. The REPORT command is best used to identify which files need a backup, unneeded backups, database physical schema, and if unrecoverable operations were performed on files.


19. What should be done to generate accurate information from the REPORT command?
A. Recently performed CHANGE command
B. Recently performed UNCATALOG command
C. Recently performed CROSSCHECK commands
D. RMAN repository synchronized with the control file
E. All of the above
---
Ans: E.
The REPORT command is accurate when the control and RMAN repository are
synchronized, which can be performed by the CHANGE, UNCATALOG, and CROSSCHECK
commands.

20. Identify the methods used to schedule a backup job. (Choose all that apply.)
A. A third-party GUI tool provided by the media management provider
B. A file that is scheduled with the operating system scheduler
C. Running the EM Maintenance utility
D. Running RMAN from CLI
---
Ans: A, B.
Third-party GUI tools provided from the media manager software and
manually scripting a file incorporated with operating system scheduler are the two
methods for scheduling a backup.