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.
Answer:C
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.