You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?()A. The index r

题目

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?()

A. The index remains invisible.

B. The index is not updated by the DML statements on the indexed table.

C. The index automatically becomes visible in order to have it updated by DML on the table.

D. The index becomes unusable but the table is updated by the DML.

E. The index is updated by the DML on the table.


相似考题
更多“You have altered a non-unique index to be invisible to determine if queries execute within ”相关问题
  • 第1题:

    9. _______you _______ stay at home today?

    A. Do ; have to

    B. Must; have to

    C. Have; to

    D. Do ; must


    正确答案:A
    9.A【解析】have to的疑问形式借助动词do来实现, must的疑问形式是将must提到主语之前,另外还需注意have to与must不能重复使用。故答案为A。

  • 第2题:

    Americans _____ millions of Christmas cards every year.

    A. change

    B. exchange

    C. attempt

    D. determine


    参考答案:B

  • 第3题:

    Positions read from this chart should,to agree with chart 3949,be ______ 0.03 minutes Northwards and 0.22 minutes Westwards.

    A.shifted

    B.removed

    C.changed

    D.altered


    正确答案:A

  • 第4题:

    —Where____you____lunch?

    —Athome.Therewasnoschoollunch

    A.did;have

    B.are;having

    C.will;have

    D.do;have


    正确答案:A

  • 第5题:

    For which of the following is a data warehouse optimized?()

    A.Backup and recovery

    B.Transactions

    C.Security

    D.Queries


    参考答案:D

  • 第6题:

    You look() What()you()?

    Atire;did;do

    Btiring;have;done

    Ctired;do;do

    Dtired;have;been doing


    D