Which statements are true regarding system-partitioned tables?

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

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

A.
Only a single partitioning key column can be specified.

B.
Traditional partition pruning and partitionwise joins are not supported on these tables.

C.
Unique local indexes cannot be created on a system-partitioned table.

D.
All DML statements must use partition-extended syntax.

E.
The same physical attributes must be specified for each partition.



Leave a Reply 0

Your email address will not be published. Required fields are marked *