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

When the equality condition is met on the key, or multiple records when it is met on the nonkey, we can retrieve a single record from the ___ index strategy

16. When the equality condition is met on the key, or multiple records when it is met on the nonkey, we can retrieve a single record from the ___ index strategy.

1. Primary
2. Secondary
3. Tertiary
4. None

Answer: B) Secondary

Explanation:

When the equality condition is met on the key, or multiple records when it is met on the nonkey, we can retrieve a single record from the secondary index strategy.