What would be the outcome of this command?

The INV_HISTORY table is created using the command: SQL>CREATE TABLE

INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by
range (inv_date) interval (numtoyminterval(1,’month’)) (partition p0 values less than
(to_date(’01-01-2005′,’dd-mm-yyyy’)), partition p1 values less than
(to_date(’01-01-2006′,’dd-mm-yyyy’))); The following data has been inserted into the
INV_HISTORY table : INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005
2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the
data belonging to the year 2006 in a single partition and issue the command: SQL> ALTER
TABLE inv_history MERGE PARTITIONS FOR(TO_DATE(’15-feb-2006′,’dd-mon-yyyy’)),
FOR(TO_DATE(’15-apr-2006′)) INTO PARTITION sys_py; What would be the outcome of
this command?

The INV_HISTORY table is created using the command: SQL>CREATE TABLE

INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by
range (inv_date) interval (numtoyminterval(1,’month’)) (partition p0 values less than
(to_date(’01-01-2005′,’dd-mm-yyyy’)), partition p1 values less than
(to_date(’01-01-2006′,’dd-mm-yyyy’))); The following data has been inserted into the
INV_HISTORY table : INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005
2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the
data belonging to the year 2006 in a single partition and issue the command: SQL> ALTER
TABLE inv_history MERGE PARTITIONS FOR(TO_DATE(’15-feb-2006′,’dd-mon-yyyy’)),
FOR(TO_DATE(’15-apr-2006′)) INTO PARTITION sys_py; What would be the outcome of
this command?

A.
It executes successfully, and the transition point is set to ‘1-apr-2006’.

B.
It executes successfully, and the transition point is set to ’15-apr-2006′.

C.
It produces an error because the partitions specified for merging are not adjacent.

D.
It produces an error because the date values specified in the merge do not match the
date values stored in the table.



Leave a Reply 0

Your email address will not be published. Required fields are marked *