Which two are true regarding a list-partitioned table? (Choose two.)
A. It is possible to partition an index-organized table using the LIST method.
B. It is NOT possible to have multiple columns as the partition key of a list partitioned table.
C. The keyword NULL can be specified as a partition literal value for one partition of a list-partitioned table.
D. The keyword MAXVALUE can be specified as a partition literal value for one partition of a list-partitioned table.
Answer: B, C
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 list-partitioned table: the set of values that specifies a partition cannot be empty; it must contain at least one value.
Incorrect Answers
A: List partitioning is supported for heap tables only. IOTs do not support this feature.
D: You cannot specify MAXVALUE. You can specify a NULL value.
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
No comments:
Post a Comment