Oracle
1Z0-067 · Question #59
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
The correct answer is D. Unique local indexes cannot be created on a system-partitioned table. E. Traditional partition pruning and partitionwise joins are not supported on these tables. See the full explanation below for the reasoning.
Question
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
Options
- AOnly a single partitioning key column can be specified.
- BAll DML statements must use partition-extended syntax.
- CThe same physical attributes must be specified for each partition.
- DUnique local indexes cannot be created on a system-partitioned table.
- ETraditional partition pruning and partitionwise joins are not supported on these tables.
How the community answered
(15 responses)- A13% (2)
- C7% (1)
- D80% (12)
Community Discussion
No community discussion yet for this question.