网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

On your Oracle Database, you issue the following commands to create indexes:SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);Which two statements are true?（）

A. Only the ORD_CUSTOMER_IX1 index created.

B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.

C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.

D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.

E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.

F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

参考答案

更多 “ On your Oracle Database, you issue the following commands to create indexes:SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);Which two statements are true?（）A. Only the ORD_CUSTOMER_IX1 index created.B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table. ” 相关考题
考题 You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
查看答案
考题 What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you
查看答案
考题 Merry Christmas, George! Here is a card for ________, with ________ best withes. A.you…yourB.you…ourC.us…ourD.us…your
查看答案
考题 Viewthisparametersettinginyourdatabase：DB_CREATE_FILE_DEST=’D：\oracle\product\10.2.0\oradata\oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）A.Thetablespacehastwodatafiles.B.Anerrorisreportedandtablespacecreationfails.C.Datafilesarecreatedwithnamesgeneratedbytheinstance.D.Thetablespacecanbeextendedwithoutspecifyingthedatafile.E.DatafilesbelongingtotheUSERStablespacecannotberenamed.
查看答案
考题 Oracle密码允许包含像“SELECT”，“DELETE”，“CREATE”这类的Oracle/SQL关键字。()
查看答案
考题 Oracle9iprovidesadatabasepackagecalleddbms_redefinitiontoperformanonlinerebuildofatable.Whichtwostepsareyourecommendedtodopriortoissuingthedbms_redefinition_start_redeftableprocedurecall?() A.Grandprivilegesontheinterimtable.B.Invokethedbms_redefinition.can_redef_tableprocedure.C.Invokethedbms_redefinition.sync_interim_tableprocedure.D.Createanytriggers，indexes，orconstraintsontheinterimtable.E.Createanemptyinterimtablewithallthedesiredcharacteristics.
查看答案
考题 ORACLE初始化参数文件的默认路径是:() A.对于UNIX，在$ORACLE_HOME/dbsB.对于UNIX，在$ORACLE_HOME/dbs/adminC.对于Linux，在%ORACLE_HOME%\databaseD.对于Windows，在%ORACLE_HOME%\dbsE.对于Windows，在%ORACLE_HOME%\database\admin
查看答案
考题 （ ） – Is Miss White __________ English teacher, Maria?– No, she teaches __________ geography.A．your；myB．you；mineC．you；usD．your；us
查看答案
考题 下列四组SQL命令，全部属于数据定义语句的命令是（）A．CREATE，DROP，UPDATEB．CREATE，DROP，ALTERC．CREATE，DROP，GRANTD．CREATE，DROP，SELECT
查看答案
考题 下列哪组SQL命令全部属于数据定义语句的命令？（）A．CREATE，DROP，ALTERB．CREATE，DROP，SELECTC．CREATE，DROP，GRANTD．CREATE，DROP，UPDATE
查看答案
热门标签
最新试卷