Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

205

积分

19

好友

29

主题
发表于 2016-6-25 13:42:15 | 查看: 539| 回复: 0
本帖最后由 biotwang 于 2016-6-25 13:46 编辑

【dbdao.com MySQL OCP认证专题】- MySQL 5.6 - OCP 考题讲解

2.

Consider the following statement on a RANGE partitioned table:
  1. ALTER TABLE orders DROP PARTITION p1, p3;
复制代码
What is the outcome of executing the above statement?
A.
Only the first partition (p1) will be dropped as only one can be dropped at any time.
B.
All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
C.
A syntax error will result as you cannot specify more than one partition in the same statement.
D.
All data in p1 and p3 partitions are removed and the table definition is changed.
--------------------------------------------------------------------

答案:D
在删除部分分区后,可以使用show create table查看其定义也一并改变了

分析:
dbdao_mysql_item_id648_0b30220a6901efcafaed7a3184cdec1d7e6cd77e.gif


参考:
http://dev.mysql.com/doc/refman/ ... ion-operations.html
您需要登录后才可以回帖 登录 | 注册

扫码加入微信Oracle小密圈


QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2018-9-25 11:52 , Processed in 0.068871 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569