Oracle 11G OCP 1Z0-053 245

(245)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.

答案:(D、E)

解析:

《Data Cartridge Developer's Guide》 8.8

System Partitioning允许你创建由多个物理分区组成的单个表.

System Partitioning不使用分区键,它会创建指定的分区数量.因此结果分区没有bound(range)、values(list)、分区方法


请使用浏览器的分享功能分享到微信等