AIncorrect Answer

Indexes are used to make searches faster - so dropping an index may slow some seek operations and leave others unchanged.

close

BIncorrect Answer

An index is NOT required to maintain a foreign key - however it is often benificial.

close

CIncorrect Answer

Indexes use additional disk space - so dropping an index should release disk space.

close

DCorrect Answer

Indexes must be maintained when inserting a record. If an index is dropped then the insertion should be faster.

close

EIncorrect Answer

In most cases updates will be faster with fewer indices.

There may be instances where an update involves a seek - in such cases the update may be slower. There is a better answer than this.

close

A B C D E TELL ME NEXT INDEX
 
 

The option of dropping a secondary index to a table is being considered. Which of the following is most likely to be a consequence of dropping the index?

  1. Certain seek operations may be faster.

  2. Certain foreign key relations may not be maintained

  3. More disk space may be required

  4. Certain insertions may be faster

  5. Certain updates may be slower