You need to crea_睦霖题库

单项选择题 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.

热门试题