πŸ“’ 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