可学答题网 > 问答 > 1z0-883题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Consider the following statement on a


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

  • AA syntax error will result as you cannot specify more than one partition in the same statement
  • BAll data in p1 and p3 partitions are removed and the table definition is changed
  • CAll data in p1 and p3 partitions are removed, but the table definition remains unchanged
  • DOnly the first partition (p1) will be dropped as only one can be dropped at any time
参考答案
参考解析:
分类:1z0-883题库