On your Oracle 12c database, you Issue the following commands to create indexesSQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);Which two statement are correct?（）A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.C. Only the ORD_CUSTOMER_IX1 index is created.D. Only the ORD_CUSTOMER_IX2 index is created.E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
On your Oracle 12c database, you Issue the following commands to create indexesSQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);Which two statement are correct?（）
A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
C. Only the ORD_CUSTOMER_IX1 index is created.
D. Only the ORD_CUSTOMER_IX2 index is created.
E. Both the indexes are updated when a new row is inserted, updated, or deleted In 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
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.
Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus，youreceivethefollowingerrormessage：SQLstartupORA-01078：failureinprocessingsystemparametersLRM-00109：couldnotopenparameterfile，C：\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN，howwouldyourespondtothiserror？（）A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.
有以下程序：当执行程序时，按下列方式输入数据（从第l列开始，<；CR>；代表回车，注意：回车也是一个字符]12<；CR>；34<；CR>；则输出结果是（ ）。A.12B.123C.1234D.12343
ORACLE初始化参数文件的默认路径是:() A.对于UNIX，在$ORACLE_HOME/dbsB.对于UNIX，在$ORACLE_HOME/dbs/adminC.对于Linux，在%ORACLE_HOME%\databaseD.对于Windows，在%ORACLE_HOME%\dbsE.对于Windows，在%ORACLE_HOME%\database\admin
当启动一个Oracle实例时,初始化参数()指出为数据文件信息保留的SGA空间的数量。 A.DB_FILESB.DB_DATAFILESC.DATABASE_FILESD.LOG_FILES
（ ） – Is Miss White __________ English teacher, Maria?– No, she teaches __________ geography.A．your；myB．you；mineC．you；usD．your；us