Oracle Exam 1Z0-888 Topic 10 Question 84 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 84
Topic #: 10

[All 1Z0-888 Questions]

old_alter_table is disabled as shown.

mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:

mysql> ALTER TABLE orders DROP PARTITION p1, p3;

What is the outcome of executing this statement?

AAll data in p1 and p3 partitions is removed and the table definition is changed.

BAll data in p1 and p3 partitions is removed, but the table definition remains unchanged.

COnly the first partition (p1) will be dropped because only one partition can be dropped at any time.

DIt results in a syntax error because you cannot specify more than one partition in the same statement.

Show Suggested Answer

Suggested Answer: B, E

by Cyndy at Jan 23, 2024, 06:08 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!