New Features for Administrators - Question 003

What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?

A. The filename format

B. Information stored inside a data dictionary table

C. Information stored in the ALERT.LOG file for the corresponding instance

D. Information stored inside the corresponding initialization parameter file for the instance

Answer: A

Explanation:

Oracle will use naming conventions when it creates the OMF files. In this naming convention, %t represents the tablespace name, %u is a unique 8-character string, and %g stands for the redo log group number.

Incorrect Answers

B: Oracle will create a locally managed tablespaces, so information about a datafile willnot be stored inside a data dictionary table.

C: Oracle does not use ALERT.LOG file to store information about datafiles. It just keeps a log of database events and database structure changes.

D: Initialization parameter file will not be used to store this information. Oracle reads this file to set initialization parameters to start the instance. The structure of the database is stored inside control files. Oracle uses them to mount and open the database.

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