可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The INV_HISTORY table 


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.
参考答案
参考解析:
分类:1Z0-053题库