重庆思庄Oracle、Redhat认证学习论坛

标题: 1z0-883 第二题 [打印本页]

作者: jikcheng 时间: 2014-12-22 11:16
标题: 1z0-883 第二题
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 时间: 2014-12-22 11:19
原文翻译：

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

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

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

作者: jikcheng 时间: 2014-12-22 11:22
Answer: B

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

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

所以答案选 B

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)