Oracle
1Z0-050 · Question #46
1Z0-050 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
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
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.