可学答题网 > 问答 > 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题库
相关推荐

1、17 Which of the following statements a

17 Which of the following statements are correct?A(1) All non-current assets must be depreciated.B(2) If goodwill is revalued, the revaluation su...

2、Consider the following&ensp

Consider the following statement:  SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (- 2> ownname => ‘O...

3、Consider the following&ensp

Consider the following configuration: /devices/D1is a member of disk group dgroupA. /devices/D2is a&ensp...

4、19 Which of the following statements a

19 Which of the following statements about intangible assets in company financial statements are correct accordingAto international accounting stan...

5、Consider the following&ensp

Consider the following command: Backup database plus archivelog delete input; How many backup sets...

6、Consider the following&ensp

Consider the following scenario: You have a directory, data, under the disk group tdgroup A....