If successful,the ALTER INDEX ...REBUILD command automatically corrects an index that has been marked ____ because a change was made to the structure of the underlying table or partition.
A) "DAMAGED"
B) "UNUSABLE"
C) "DIRTY"
D) "ALTERED"

Question

Quizplus · Accepted Answer

When a change is made to the structure of the underlying table or partition, the index becomes unusable and needs to be rebuilt. The ALTER INDEX ...REBUILD command automatically corrects this issue and rebuilds the index, making it usable again. Therefore, the correct answer is B, "UNUSABLE".

If Successful,the ALTER INDEX