Oracle
1Z0-050 · Question #67
1Z0-050 Question #67: Real Exam Question with Answer & Explanation
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.
Community Discussion
No community discussion yet for this question.