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)、分割槽方法

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1266706/，如需轉載，請註明出處，否則將追究法律責任。