itgle.com

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);Whi

题目

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 > CREAT ”相关问题
  • 第1题:

    Oracle密码允许包含像“SELECT”,“DELETE”,“CREATE”这类的Oracle/SQL关键字。()


    答案:错误

  • 第2题:

    ORACLE初始化参数文件的默认路径是:()

    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


    参考答案:A

  • 第3题:

    下列四组SQL命令,全部属于数据定义语句的命令是()

    A.CREATE,DROP,UPDATE

    B.CREATE,DROP,ALTER

    C.CREATE,DROP,GRANT

    D.CREATE,DROP,SELECT


    CREATE , DROP , ALTER

  • 第4题:

    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.


    参考答案:B, E

  • 第5题:

    ( ) – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A.your;my

    B.you;mine

    C.you;us

    D.your;us


    正确答案:D

  • 第6题:

    下列哪组SQL命令全部属于数据定义语句的命令?()

    A.CREATE,DROP,ALTER

    B.CREATE,DROP,SELECT

    C.CREATE,DROP,GRANT

    D.CREATE,DROP,UPDATE


    CREATE,DROP,ALTER