单选题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 state

题目
单选题
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


相似考题