Thursday, June 14, 2007

Oracle 10g OCP Admin II - Ch2 Using Recovery Manager

Oracle 10g OCP Admin II - Ch2 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
---
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.
Ans: A.

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
---------
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.
Ans C.

4. Which command creates an image copy?
A. BACKUP AS COPY

No comments: