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


    Question

    A data analyst frequently performs range queries (e.g.,

    "find all records where salary is between X and Y"). Which type of indexing is generally most effective for such queries?
    A Hash Index Correct Answer Incorrect Answer
    B Full-text Index Correct Answer Incorrect Answer
    C B-tree Index Correct Answer Incorrect Answer
    D Bitmap Index Correct Answer Incorrect Answer
    E Spatial Index Correct Answer Incorrect Answer

    Solution

    B-tree indexes maintain data in sorted order, which allows for very efficient retrieval of data within a specified range. Hash indexes, in contrast, do not preserve order.

    Practice Next
    ask-question