You need to create&ens

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.