Home » MCQs » SQL MCQs » SQL Index MCQs

Which of the following states the correct situation in which Indexes should not be used in SQL?

10. Which of the following states the correct situation in which Indexes should not be used in SQL?

1. When the table is small, it is possible to avoid using SQL indexes.
2. Updates need to be made frequently to the table.
3. When there are a lot of NULL values in a column, indexed should not be used.
4. All of the above

Answer: D) All of the above

Explanation:

In the case of following situation, Indexes should not be used in SQL –

1. When the table is small, it is possible to avoid using SQL indexes.
2. Updates need to be made frequently to the table.
3. When there are a lot of NULL values in a column, indexed should not be used.