单选题

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?()

AA syntax error will result as you cannot specify more than one partition in the same statement

BAll data in p1 and p3 partitions are removed and the table definition is changed

CAll data in p1 and p3 partitions are removed, but the table definition remains unchanged

DOnly the first partition (p1) will be dropped as only one can be dropped at any time

正确答案

来源:www.examk.com

答案解析