Create a custom practice set
Pick category, difficulty, number of questions, and time limit. Start instantly with your own quiz.
Generate QuizGK Question
Which database index type is best suited for range queries like 'BETWEEN' or 'greater than'?
- Hash Index
- B-Tree Index
- Bitmap Index
- Inverted Index
Answer: B-Tree Index
B-Tree indexes maintain sorted data and allow efficient range queries, equality searches, and ordered retrieval. Hash indexes are optimal only for exact match lookups. Bitmap indexes work well for low-cardinality columns. Inverted indexes are used in full-text search engines.