itgle.com

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clau

题目

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）

A. disabling the index

B. making the index invisible

C. making the index unusable

D. using the MONITORING USAGE clause for the index

相似考题

1.How long() you() a member of the club?A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

2.At last we got the letter we had long () expecting.A. areB. wereC. beD. been

3.Whichfouraretrue?()A.Has-arelationshipsshouldneverbeencapsulated.B.Has-arelationshipsshouldbeimplementedusinginheritance.C.Has-arelationshipscanbeimplementedusinginstancevariables.D.Is-arelationshipscanbeimplementedusingtheextendskeyword.E.Is-arelationshipscanbeimplementedusingtheimplementskeyword.F.Anarrayoracollectioncanbeusedtoimplementaone-to-manyhas-arelationship.G.TherelationshipbetweenMovieandActressisanexampleofanis-arelationship.

4.Why()the old block of flats()demolished next month?A、are…beingB、is…beingC、has…beenD、have…been

参考答案和解析
参考答案：B
更多“An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS tabl ”相关问题

  • 第1题：

    He is talking so much about America as if he ____ there.

    A、had been

    B、has been

    C、was

    D、been


    正确答案：A

  • 第2题：

    TheORDERStablebelongstotheuserOE.OEhasgrantedtheSELECTprivilegeontheORDERStabletotheuserHR.WhichstatementwouldcreateasynonymORDsothatHRcanexecutethefollowingquerysuccessfully?()

    A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE

    B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE

    C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

    D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator


    参考答案：D

  • 第3题：

    设置多列布局的属性值为（）。

    A．columns-width

    B．column-count

    C．column-gap

    D．column-rule


    A 解析：Columns属性返回或设置一个值，以决定控件是水平还是垂直滚动以及如何显示列中的项目。Columns属性值为0时，控件为垂直滚动；Columns属性等于1时，则列表框呈多行多列显示： Columns属性值大于1时，为水平滚动，Columns属性值的数量决定在控件中的可见宽度内显示列的数量。Columns属性用来确定列表框的列数。

  • 第4题：

    Examinethefollowingoutput：SQL>SELECTindex_name，statusFROMdba_indexesWHEREstatus=’UNUSABLE’；INDEX_NAMESTATUS-----------------------------------------EINDUNUSABLEWhichtwostatementsabouttheaboveindexaretrue（）

    A.Itisignoredbythequeryoptimizer.

    B.Itisnotusedwhiletheindexisbeingrebuilt.

    C.Theindexcannotberebuilt，andhastobere-created.

    D.Theindexisautomaticallyrebuiltwhenusedthenexttime


    参考答案：A, B

  • 第5题：

    Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）

    CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG

    MAXLOGFILES20

    MAXLOGMEMBERS3

    MAXDATAFILES30

    MAXINSTANCES10

    MAXLOGHISTORY1200

    LOGFILE

    GROUP1（

    ’/disk1/prod/orders/db/log1a.dbf’，

    ’/disk2/prod/orders/db/log1b.dbf’

    ）SIZE100K

    GROUP2（

    ’/disk1/prod/orders/db/log2a.dbf’，

    ’/disk2/prod/orders/db/log2b.dbf’

    ）SIZE100K，

    DATAFILE

    ’/disk1/prod/orders/db/database1.dbf’，

    ’/disk2/prod/orders/db/file1.dbf’；


    参考答案：B

相关内容