The TYPE clause used in the creation of an external table defines which access driver is used to convert the data when needed by SQL statements inside the database. Which type of access driver is supported for external tables?
A. Import
B. ORACLE_LOADER
C. Metadata API
D. Direct path export
Answer: B
Explanation:
ORACLE_LOADER is the default access driver for external tables.
Incorrect Answers
A: Import is not the default access driver for external tables.
C: Metadata API is not used to convert the data as an access driver.
D: External tables are not processed with direct path export.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 131-134
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 111-116
Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features
No comments:
Post a Comment