|
Explanation: External tables are read-only tables whose data resides in an external OS flat file, and whose definition is stored inside the database. Indexes cannot be created on external tables. Incorrect Answer: 1: External tables cannot be updated. They are read-only tables. 3: Indexes cannot be created on external tables. Reference: OCP Oracle 9i 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 Oracle 9i Database DDS and Data-Warehouse Features
|