Updated latest Oracle 1Z0-883 dumps exam practice questions and answers online free try. https://www.lead4pass.com/1z0-883.html dumps pdf practice materiasls. Oracle Database 1Z0-883 dumps exam training resources which are the best for clearing 1Z0-883 exam test, pass Oracle 1z0-883 exam quickly and easily at first try, 100% pass guarantee.
QUESTION 1
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.