1z0-883 第二题

jikcheng

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.  Only the first partition (p1) will be dropped as only one can be dropped at any time.
B.  All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
C.  A syntax error will result as you cannot specify more than one partition in the same statement.

D.  All data in pi and p3 partitions are removed and the table definition is changed.

[此贴子已经被作者于2014-12-22 11:17:32编辑过]

jikcheng

Answer: B

DROP 分区是把 分区删除，并且删除分区数据。但表的字段信息却不会变。

remove 是移除分区，保留数据。同样表的字段信息不会变。

所以答案选 B

jikcheng

原文翻译：

考虑以下语句在一个range 分区表上： alter table orders drop partition p1 , p3;

关于这个语句执行输出哪个是正确的。

[此贴子已经被作者于2014-12-22 11:19:35编辑过]