Which statements are true regarding system-partitioned tables? (Choose all that apply.)
A.
Only a single partitioning key column can be specified.
B.
All DML statements must use partition-extended syntax.
C.
The same physical attributes must be specified for each partition.
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.
https://docs.oracle.com/cd/B28359_01/server.111/b32024/partition.htm
System Partitioning
System partitioning enables application-controlled partitioning without having the database controlling the data placement. The database simply provides the ability to break down a table into partitions without knowing what the individual partitions are going to be used for. All aspects of partitioning have to be controlled by the application. For example, an insertion into a system partitioned table without the explicit specification of a partition will fail.
System partitioning provides the well-known benefits of partitioning (scalability, availability, and manageability), but the partitioning and actual data placement are controlled by the application.