多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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?()

  • A、A syntax error will result as you cannot specify more than one partition in the same statement
  • B、All data in p1 and p3 partitions are removed and the table definition is changed
  • C、All data in p1 and p3 partitions are removed, but the table definition remains unchanged
  • D、Only the first partition (p1) will be dropped as only one can be dropped at any time
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题