Multiple choice technology databases

In which scenarios would you rebuild an index?

  1. when you need to disable the index usage

  2. when you need to move the index to another tablespace

  3. when you need to enable index monitoring

  4. none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Rebuilding an index recreates it from scratch, which is necessary when moving the index to a different tablespace. Options A and C are incorrect - disabling/enabling index usage or monitoring don't require rebuild. Rebuilding is also used for defragmentation or to change storage parameters, but not for the administrative operations in A and C.

Keep practicing — related questions