New Features for Administrators - Question 054

Examine the following parameter settings from an initialization (init.ora) file:

DB_CREATE_FILE_DEST = '/u01/oradata/'
DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata/'
DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata/'

If you create an Oracle Managed Files (OMF) database using these settings, what is the result?

A. The data files, temp files, and control file will be on device /u01; one online redo

log group will be on device /u02; another redo log group will be on device /u03.

B. The data files and temp files will be on device /u01; one copy of the control file and one online redo log group will be on device /u02; another copy of the control file and a second redo log group will be on device /u03.

C. The data files, temp files, online redo log files, and control file will be on device /u01; multiplexed copies of the archive log files will be created: one set on device /u02, and another set on device /u03.

D. The data files and temp files will be on device /u01; one copy of the control file and the first member in each online redo log group will be on device /u02; another copy of the control file and a second member of each redo log group will be on device /u03.

Answer: D

Explanation:

The data files and temp files directory name is set by the DB_CREATE_FILE_DEST parameter. If you use Oracle Managed Files Locations for the control files are set by the DB_CREATE_ONLINE_LOG_DEST_1 and DB_CREATE_ONLINE_LOG_DEST_2 parameters.

Incorrect Answers

A: Control file will not be located on device /u01. One copy of the control file and the first member in each online redo log group will be on device /u02; another copy of the control file and a second member of each redo log group will be on device /u03.

B: Each redo log copy will have the first member on device /u02 and a second member will be on device /u03.

C: Online redo log files, and control file will not be on device /u01.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 2-12

Chapter 1: Oracle9i Database Administration and Management Features