📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • âś–

      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
      More SQL Questions
      ask-question