|
Explanation: Oracle9i has introduced a new package called DBMS_METADATE that enables you to retrieve all the attributes of the database object from the data dictionary with one invocation. Also you can use other methods, available in earlier versions of Oracle for documenting the objects in an existing database: query the various tables in the data dictionary to obtain information about an object, export/import utilities, OCIDescribeAny interface. Incorrect Answers: 1: The Metadata Application Programming Interface (API) does not allow you to repair damaged data dictionary entries. 2: It is not used to delete data dictionary information about database objects you no longer need. 4: The Metadata Application Programming Interface (API) does not prepare pseudocode modules for conversion to Java or PL/SQL programs. Reference: OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 136-138 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 44-46 Chapter 2: Oracle9i Architecture Changes
|