Oracle Exam 1Z0-067 Topic 6 Question 18 Discussion

Actual exam question for Oracle's 1Z0-067 exam

Question #: 18
Topic #: 6

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

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.

Show Suggested Answer

Suggested Answer: D, E

by Gwenn at May 04, 2022, 08:50 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!