Oracle
1Z0-034 · Question #34
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
(47 responses)- A13% (6)
- B2% (1)
- C6% (3)
- D79% (37)
Community Discussion
No community discussion yet for this question.