|
Explanation: It is NOT possible to have multiple columns as the partition key of a list-partitioned table. It’s possible to specify the keyword NULL as a partition literal value for one partition of a listpartitioned table: the set of values that specifies a partition cannot be empty; it must contain at least one value. Incorrect Answers: 1: List partitioning is supported for heap tables only. IOTs do not support this feature. 4: You cannot specify MAXVALUE. You can specify a NULL value. 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
|