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.
第1题:
Oracle密码允许包含像“SELECT”,“DELETE”,“CREATE”这类的Oracle/SQL关键字。()
第2题:
A.对于UNIX,在$ORACLE_HOME/dbs
B.对于UNIX,在$ORACLE_HOME/dbs/admin
C.对于Linux,在%ORACLE_HOME%\database
D.对于Windows,在%ORACLE_HOME%\dbs
E.对于Windows,在%ORACLE_HOME%\database\admin
第3题:
下列四组SQL命令,全部属于数据定义语句的命令是()
A.CREATE,DROP,UPDATE
B.CREATE,DROP,ALTER
C.CREATE,DROP,GRANT
D.CREATE,DROP,SELECT
第4题:
A.Grandprivilegesontheinterimtable.
B.Invokethedbms_redefinition.can_redef_tableprocedure.
C.Invokethedbms_redefinition.sync_interim_tableprocedure.
D.Createanytriggers,indexes,orconstraintsontheinterimtable.
E.Createanemptyinterimtablewithallthedesiredcharacteristics.
第5题:
( ) – Is Miss White __________ English teacher, Maria?
– No, she teaches __________ geography.
A.your;my
B.you;mine
C.you;us
D.your;us
第6题:
下列哪组SQL命令全部属于数据定义语句的命令?()
A.CREATE,DROP,ALTER
B.CREATE,DROP,SELECT
C.CREATE,DROP,GRANT
D.CREATE,DROP,UPDATE