Oracle
1Z0-050 · Question #46
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…
The correct answer is C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with. See the full explanation below for the reasoning.
Question
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?
Options
- AIt returns an error because the range partitions P1 and P2 should be of the same range.
- BIt 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
- DIt returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match
How the community answered
(27 responses)- A4% (1)
- B11% (3)
- C81% (22)
- D4% (1)
Community Discussion
No community discussion yet for this question.