多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题