|
Explanation: At least one element needs to be defined for each partition of the table. The set of values that specifies a partition cannot be empty; it must contain at least one value. Incorrect Answers: 1: You can create global range partitioned indexes on the table. 2: The optimizer will execute partition wise joins on the table's partitions. 4: Partition pruning will occur during query optimization if a range of values is included in the query predicate. Reference: OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 134-136 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 102-107 Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features
|