Oracle OCP 1Z0-053 (System Partitioning)
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.
Answer: DE
参考：http://blog.csdn.net/rlhua/article/details/17008263
http://docs.oracle.com/cd/E11882_01/appdev.112/e10765/dom_idx.htm#ADDCI4490
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.
Answer: DE
参考：http://blog.csdn.net/rlhua/article/details/17008263
http://docs.oracle.com/cd/E11882_01/appdev.112/e10765/dom_idx.htm#ADDCI4490
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2072179/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
