Mysql OCP 45题

old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;https://www.cndba.cn/hbhe0316/article/22784

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?
A. All data in p1 and p3 partitions is removed and the table definition is changed.
B. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
C. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
D. It results in a syntax error because you cannot specify more than one partition in the same statement.
Answer: A

https://www.cndba.cn/hbhe0316/article/22784

https://www.cndba.cn/hbhe0316/article/22784

https://www.cndba.cn/hbhe0316/article/22784

https://www.cndba.cn/hbhe0316/article/22784

---

在范围分区表上执行如下语句：
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
下面哪项说法是对的？
A．P1和P3分区被删除，表的定义发生改变
B．P1和P3分区被删除，表的定义未发生改变
C．只有P1分区被删除，因为一次只能删除一个分区
D．DDL语句报语法错误https://www.cndba.cn/hbhe0316/article/22784https://www.cndba.cn/hbhe0316/article/22784https://www.cndba.cn/hbhe0316/article/22784https://www.cndba.cn/hbhe0316/article/22784

https://www.cndba.cn/hbhe0316/article/22784

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL