📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    Question

    Which index type is most beneficial for queries that use

    range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
    A Hash index Correct Answer Incorrect Answer
    B B-tree index Correct Answer Incorrect Answer
    C Bitmap index only Correct Answer Incorrect Answer
    D No index Correct Answer Incorrect Answer
    E Reverse key index Correct Answer Incorrect Answer

    Solution

    B-tree (or B+ tree) preserves order and supports efficient range scans; hash indexes don't support range queries effectively.

    Practice Next
    ask-question