old_alter_table is disabled as shown.

Oracle 1z0-888 Question Answer

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?

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

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

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

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

Oracle 1z0-888 Summary

Price: $52.5 ~~$149.99~~