Oracle
1Z0-883 · Question #54
1Z0-883 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
Question
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?
Options
- AOnly the first partition (p1) will be dropped as only one can be dropped at any time.
- BAll data in p1 and p3 partitions are removed, but the table definition remains unchanged.
- CA syntax error will result as you cannot specify more than one partition in the same statement.
- DAll data in pi and p3 partitions are removed and the table definition is changed.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.