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.
- 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.
正确答案:C
答案解析:有

微信扫一扫手机做题