New Features for Administrators - Question 009

If you create your database using Oracle Managed Files (OMF), what is true?

A. You must use Oracle predefined names to identify raw partitions that will hold OMF structures.

B. You must define directories for two online redo log groups and three copies of the control file.

C. If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.

D. You must use only OMF data files when adding new tablespaces or data files to your database in the future.

Answer: D

Explanation:

If you created your database using Oracle Managed Files (OMF), you must use only OMF data files when adding new tablespaces or data files to your database in the future.

Incorrect Answers

A: You don’t need to use Oracle predefined names to identify raw partitions that will hold OMF structures.

B: You should define directories for OMF datafiles, redo log files and control files. Oracle9i gives you two new initialization parameters, DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n, to specify the location where Oracle will create and manage OMFs; n can take a value from 1 to 5. So there is no limitation on control files amount to 3 copies.

C: If your CREATE DATABASE command fails, any OMF database files that have already been created will not be dropped automatically. This feature will work for the OMF datafiles only after successful database creation.

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