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 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 look(). What () you () ? A、tire, did…doB、tiring, have…doneC、tired, do…doD、tired, have…been doing
9. _______you _______ stay at home today?A. Do ; have toB. Must; have toC. Have; toD. Do ; must
Americans _____ millions of Christmas cards every year.A. changeB. exchangeC. attemptD. determine
For which of the following is a data warehouse optimized?() A.Backup and recoveryB.TransactionsC.SecurityD.Queries
Positions read from this chart should,to agree with chart 3949,be ______ 0.03 minutes Northwards and 0.22 minutes Westwards.A.shiftedB.removedC.changedD.altered
You look() What()you()?Atire;did;doBtiring;have;doneCtired;do;doDtired;have;been doing