You need to create a partitioned table to store historical data and you issued the following command: 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.
- CIt 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.