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

In the case of Secondary Index, comparison, the files scan scans the blocks of the lowest-level index to satisfy the selection operation involving the characters ____, or >=

21. In the case of Secondary Index, comparison, the files scan scans the blocks of the lowest-level index to satisfy the selection operation involving the characters ____, or >=.

1. < 
2. > 
3. <=
4. All of the above

Answer: D) All of the above

Explanation:

In the case of Secondary Index, comparison, the files scan scans the blocks of the lowest-level index to satisfy the selection operation involving the characters <, >, <=, or >=.