DA0-002 Data Concepts and Environments Practice Question
Which database index type is most commonly used for exact-match lookups and range queries in a B-tree structure?
⚠ Common exam trap
Candidates often confuse 'clustered index' as a separate index type, but it is actually a physical implementation of a B-tree where the leaf nodes contain the full row data, not a different algorithmic structure.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
B-tree index
A B-tree index is the correct answer because it maintains sorted data in a balanced tree structure, enabling both exact-match lookups (via equality searches) and efficient range queries (via ordered traversal of leaf nodes). This dual capability makes it the standard index type in relational databases like MySQL, PostgreSQL, and Oracle for general-purpose querying.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
B-tree index
Why this is correct
B-tree indexes support both exact-match and range queries.
- ✗
Hash index
Why it's wrong here
Hash indexes support only exact-match lookups, not range queries.
- ✗
Clustered index
Why it's wrong here
Clustered index defines the physical order, but B-tree is the structure type; however, the question asks for index type, and B-tree is the structure often used.
- ✗
Bitmap index
Why it's wrong here
Bitmap indexes are used for low-cardinality columns, not general-purpose.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.