New Features for Administrators - Question 078

Which is a restriction on a list partitioned table?

A. You cannot create global range partitioned indexes on the table.

B. The optimizer will not execute partition wise joins on the table's partitions.

C. You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL.

D. Partition pruning will not occur during query optimization if a range of values is included in the query predicate.

Answer: C

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

A: You can create global range partitioned indexes on the table.

B: The optimizer will execute partition wise joins on the table's partitions.

D: Partition pruning will occur during query optimization if a range of values is included in the query predicate.

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