移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

You need to create a partitioned table to store historical data and you issued the following command:   CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL (NUMTOYMINTERVAL(1,’month’)) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESS THAN(TO_DATE(’1-1-2005’, ’dd-mm-yyyy’)), PARTITION p2 VALUES LESS THAN(TO_DATE(’1-1- 2007’, ’dd-mm-yyyy’)))  AS SELECT * FROM purchases WHERE time_id < TO_DATE(’1-1-2007’,’dd-mm-yyyy’);   What is the outcome of the above command?()  

发布日期:2021-07-31

You need to create a partitioned table to store hi...
A

It returns an error because the range partitions P1 and P2 should be of the same range.

B

It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.

C

It creates two range partitions of varying range. For data beyond ’1-1-2007,’ it creates partitions with a width of one month each.

D

It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!