Oracle
1Z0-883 · Question #54
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?
The correct answer is D. All data in pi and p3 partitions are removed and the table definition is changed. See the full explanation below for the reasoning.
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.
How the community answered
(26 responses)- A4% (1)
- B8% (2)
- C15% (4)
- D73% (19)
Community Discussion
No community discussion yet for this question.