Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）<br>A:A syntax error will result as you cannot specify more than one partition in the same statement<br>B:All data in p1 and p3 partitions are removed and the table definition is changed<br>C:All data in p1 and p3 partitions are removed, but the table definition remains unchanged<br>D:Only the first partition (p1) will be dropped as only one can be dropped at any time

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）
A:A syntax error will result as you cannot specify more than one partition in the same statement
B:All data in p1 and p3 partitions are removed and the table definition is changed
C:All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D:Only the first partition (p1) will be dropped as only one can be dropped at any time

出自：Oracle认证

提示：
同一【IP】的非会员用户每天可免费获取10次答案

收藏本站【zk.995w.com】，下次访问不迷路

本站试题总数:【10245188】个 (题库试题定时更新)