网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “ The INV_HISTORY table is created using the command： SQLCREATE 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.” 相关考题
考题
Bootstrap中,通过对表格调用类()可实现响应式表格。
A..table-condensedB..table-stripedC..table-hoverD..table-responsive
考题
Which syntax turns an existing constraint on? ()
A. ALTER TABLE table_name ENABLE constraint_name;B. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C. ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D. ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()
A. ALTER TABLE SPLIT PARTITIONB. ALTER TABLE MERGE PARTITIONC. ALTER TABLE TRUNCATE PARTITIOND. ALTER TABLE ADD PARTITIONE. ALTER TABLE DROP PARTITIONF. ALTER TABLE MOVE PARTITION
考题
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
考题
In what location are EIGRP successor routes stored?()
A. In the routing table only.B. In the neighbor table only.C. In the topology table only.D. In the routing table and neighbor table.E. In the routing table and topology table.F. In the topology table and neighbor table.
考题
In what location are EIGRP successor routes stored?（）A、In the routing table only.B、In the neighbor table only.C、In the topology table only.D、In the routing table and neighbor table.E、In the routing table and topology table.F、In the topology table and neighbor table.
考题
Which syntax turns an existing constraint on?（）A、ALTER TABLE table_name ENABLE constraint_name;B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;C、ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;D、ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;E、ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
考题
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
考题
如下能正确执行的语句是（）A、select * from table_name where 1=2B、truncate table table_nameC、delete from table_name where null=nullD、alter table table_name add column idd int
考题
Which action(s) will cause a compression dictionary to be removed from a table?（）A、Set the table COMPRESS attribute to NO. B、Set the table COMPRESS attribute to NO; run REORG against the table. C、Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table. D、Set the table COMPRESS attribute to NO; run RUNSTATS against the table.
考题
Which statement is correct about the forwarding table?（）A、The forwarding table is stored only on the PFEB、The forwarding table contains all known routesC、The forwarding table is stored on both the RE and PFED、The forwarding table is stored only on the RE
考题
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）A、No flashback is possible to bring back the ITEM table.B、The ORDERS table is dropped along with the ITEM table.C、The dependent referential integrity constraints in the ORDERS table are disabled.D、The dependent referential integrity constraints in the ORDERS table are removed.E、The table definition of the ITEM table and associated indexes are placed in the recycle bin
考题
单选题In what location are EIGRP successor routes stored?（）A
In the routing table only.B
In the neighbor table only.C
In the topology table only.D
In the routing table and neighbor table.E
In the routing table and topology table.F
In the topology table and neighbor table.
考题
多选题You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）ANo flashback is possible to bring back the ITEM table.BThe ORDERS table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDERS table are disabled.DThe dependent referential integrity constraints in the ORDERS table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin
考题
单选题The INV_HISTORY table is created using the command: You would like to store the data belonging to the year 2006 in a single partition and issue the command: 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 enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）A
Drop the table.B
Partition the tableC
Truncate the table.D
Add a column to the table.E
Rename a column in the table.
考题
多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
考题
多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION
考题
单选题You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）A
Drop the table.B
Partition the table.C
Truncate the table.D
Add a column to the table.E
Rename a column in the table.
考题
多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION
考题
多选题Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）AYou cannot roll back this statement.BAll pending transactions are committed.CAll views based on the DEPT table are deleted.DAll indexes based on the DEPT table are dropped.EAll data in the table is deleted, and the table structure is also deleted.FAll data in the table is deleted, but the structure of the table is retained.GAll synonyms based on the DEPT table are deleted.
考题
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command.
考题
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command
考题
单选题Which syntax turns an existing constraint on?（）A
ALTER TABLE table_name ENABLE constraint_name;B
ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;C
ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;D
ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;E
ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
热门标签
最新试卷
