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. syntax error will result as you cannot specify more than one partition in the same statement
B. ll data in p1 and p3 partitions are removed and the table definition is changed
C. ll 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
查看答案
该试题由用户737****34提供
查看答案人数:14255
如遇到问题请
联系客服
正确答案
该试题由用户737****34提供
查看答案人数:14256
如遇到问题请联系客服