Home » MCQs » DBMS MCQs » DBMS Selection Operation in Query Processing MCQs

The secondary index becomes ___ if there are many records to fetch

25. The secondary index becomes ___ if there are many records to fetch.

1. Cheap
2. Expensive
3. Not costly
4. None

Answer: B) Expensive

Explanation:

The secondary index becomes expensive if there are many records to fetch.