Difficulty: Easy
Correct Answer: both (a) and (b)
Explanation:
Introduction / Context:
Indexes speed up data retrieval by maintaining a compact, searchable structure separate from the base data. Understanding what an index stores helps clarify how lookups translate to locating the actual record in the master file or table.
Given Data / Assumptions:
Concept / Approach:
An index is a data structure that stores keys (values on which you search/sort) and pointers (references) to the corresponding records or to lower-level index pages. This allows logarithmic-time searches and ordered traversals, avoiding full scans of the master data.
Step-by-Step Solution:
Identify index content: keys plus references to data/pages.Relate pointers to record identifiers (RIDs) or page numbers in DBMS terms.Conclude that both keys and pointers are essential components.Choose “both (a) and (b).”
Verification / Alternative check:
B-tree/B+-tree descriptions show that each entry pairs a key with a pointer (to child node or to data), confirming the dual structure.
Why Other Options Are Wrong:
Keys only: without pointers, keys cannot lead you to data.
Common Pitfalls:
Confusing clustered storage (where data pages are ordered by key) with the index itself; even clustered indexes still maintain key-pointer relationships.
Final Answer:
both (a) and (b)
Discussion & Comments