What is the outcome of executing the above statement?

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?

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 pi 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.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


amuc

amuc

B

mukhti

mukhti

Hey Amuc! Have you taken the exam already?

igbinigun

igbinigun

Agree B

Karthik

Karthik

Agree with B .