Oracle
1Z0-050 · Question #67
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
(38 responses)- A5% (2)
- B8% (3)
- C16% (6)
- D71% (27)
Community Discussion
No community discussion yet for this question.