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.