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

Oracle认证考试

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

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

  • 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.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题