OCP: Oracle9i DBA Fundamentals II Study Guide
Review Questions
1. Does the RMAN utility require the use of the recovery catalog?
A. The recovery catalog is required.
B. The recovery catalog is not required.
C. The recovery catalog is required if it is stored in the same database as the target database.
D. The recovery catalog is not required if it is stored in the same database as the target database.
---
The recovery catalog is optional regardless of the configuration of the target database. It is used to store information about the backup and recovery process in much the same way that the data dictionary stores information about the database.
Ans: B.
2. What are some of the capabilities of the RMAN utility? (Choose all that apply.)
A. Backs up databases, tablespaces, data files, control files, and archived logs
B. Compresses backups
C. Provides scripting capabilities
D. Tests whether backups can be restored
E. All of the above
---
All answers are capabilities of the RMAN utility.
Ans: E.
3. What type of interface does the RMAN utility support? (Choose all that apply.)
A. GUI through Oracle Enterprise Manager
B. Command-line interface
C. Command line only
D. GUI through Oracle Enterprise Manager only
---
The RMAN utility can be run in GUI mode via the use of Oracle Enterprise Manager or through a command-line interface on the server.
Ans: A, B.
4. What actions can be performed within the RMAN utility? (Choose all that apply.)
A. Start up target database.
B. Shut down target database.
C. Grant roles to users.
D. Create user accounts.
---
The RMAN utility can start and stop a target database. Database objects and users’ accounts are not created with the RMAN utility.
Ans: A, B.
5. The tape media management library (MML) enables RMAN to perform which of the following? (Choose all that apply.)
A. Interface with third-party tape hardware vendors.
B. Use third-party automated tape libraries (ATLs).
C. Write to any tape.
D. Write to disk.
---
The tape media library enables RMAN to interface with other tape hardware vendors and use their automated tape library systems. Writing to disk and tape can still be performed by using special tape libraries.
Ans: A, B.
6. Which of the following commands is used in automatic channel allocation?
A. ALLOCATE CHANNEL C1 TYPE DISK
B. ALLOCATE CHANNEL C1 TYPE ‘SBT_TAPE’
C. CONFIGURE DEFAULT DEVICE TYPE
D. CONFIGURE DEFAULT TYPE DEVICE
---
The CONFIGURE DEFAULT DEVICE TYPE command is used during automatic channel allocation. The CONFIGURE DEFAULT TYPE DEVICE command is incorrect and the other examples are manual channel allocation examples.
Ans: C
7. Which of the following commands are examples of those used in the manual channel allocation process? (Choose all that apply.)
A. ALLOCATE CHANNEL T1 TYPE DISK
B. ALLOCATE CHANNEL T1 TYPE ‘SBT_TAPE’
C. CONFIGURE DEFAULT DEVICE TYPE
D. CONFIGURE DEFAULT TYPE DEVICE
---
Both examples with ALLOCATE CHANNEL as a part of the command are examples of manual channel allocation. The other examples, C and D, are not manual channel allocation.
Ans: A, B.
8. Which of the following media management libraries are provided with most RMAN installations?
A. MMLs that support Legato Storage Manager software.
B. MMLs that support Disk.
C. MMLs are not supplied.
D. MMLs are not necessary for proprietary tape hardware.
---
The MMLs that are installed with most RMAN installations support the Legato Storage Manager.
Ans: A.
9. Which of the following commands would you use to set the default parallelism for a RMAN session?
A. SET DEVICE TYPE PARALLELISM
B. CONFIGURE DEVICE TYPE PARALLELISM
C. INSTALL DEVICE TYPE PARALLELISM
D. CONFIG DEVICE TYPE PARALLELISM
----
The CONFIGURE DEVICE TYPE PARALLELISM command will set a default parallelism value.
Ans: B.
10. Which of the following commands cannot be used without a recovery catalog? (Choose all that apply.)
A. RESYNCH CATALOG
B. RESET DATABASE
C. REPLACE SCRIPT
D. LIST INCARNATION
E. All of the above
-----
None of these commands can be used unless you have implemented the recovery catalog.
Ans: E.
11. Which of the following commands best describes manual channel allocation? (Choose all that apply.)
A. CONFIGURE DEFAULT DEVICE TYPE
B. CONFIGURE CHANNEL DEVICE TYPE
C. ALLOCATE CHANNEL
D. ALLOCATE CHANNEL
---
Both of these options are methods of manual channel allocation. SBT_TAPE supports tape allocation and DISK supports disk allocation.
Ans: C, D.
12. Which of the following commands automatically backs up the control file?
A. SET CONTROLFILE AUTOBACKUP ON
B. CONFIGURE CONTROLFILE AUTOBACKUP ON
C. CONFIGURE CONTROLFILE AUTO ON
D. CONFIGURE CONTROLFILE AUTOBACKUP TRUE
---
The CONFIGURE CONTROLFILE AUTOBACKUP ON command will configure the control file to be automatically backed up.
Ans: B.
13. Which of the following files best describes the default media management library for Unix?
A. libobk.sl
B. libobk.so
C. obklib.so
D. libmml.so
---
The file is the default media management library. This must be replaced or pointed to whatever vendor is being used.
Ans: B.
14. Study the following command and then choose the option that best describes what this command does.
RMAN> connect target /
A. Connects to the recovery catalog
B. Connects to the target database
C. Connects to the target database and the recovery catalog
D. Connects to neither the target database nor the recovery catalog
---
This command connects to the target database.
Ans: B.
15. What is the maximum size for the RMAN repository if the recovery catalog is not being used?
A. Dependent on OS file size limitations
B. No limits
C. 2 gigabytes
D. 4 gigabytes
----
The RMAN repository is the target database control file if the recovery catalog is not being used. The size of any file is dependent on the OS in which it resides.
Ans: A.
No comments:
Post a Comment