[单选]
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.

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（） Parallel compilation of only the stored PL/SQL code。 Sequential recompilation of only the stored PL/SQL code。 Parallel recompilation of any stored PL/SQL code。 Sequential recompilation of any stored PL/SQL code。 Parallel recompilation of Java code。 Sequential recompilation of Java code。消费小说《暴风骤雨》和《山乡巨变》的作者是（）赵树理。丁玲。周立波。柳青。 You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （） GET_RELATION_PROPERTY 。 SET_RELATION_PROPERTY 。 GET_BLOCK_PROPERTY 。 GET_FORM_PROPERTY。以下几组玩具中，侧重于促进儿童智力发展的玩具是（）拼图、拼板、镶嵌板、魔方、棋类玩具。积木、积塑、橡皮泥、沙、雪。秋千、木马、平衡木、皮球、跳绳。口琴、铃鼓、铃铛、不倒翁、笛子。

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？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-053题库

相关题目: