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 month wise
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.