← Quiz: Indexing: all 10 questions
Quiz: Indexing · Question 1 of 10
Without a usable index, how does the database find matching rows?
Without a usable index, how does the database find matching rows?
- A.Binary search
- B.A full table scan — it checks every row
- C.It guesses
- D.It uses the primary key always
Answer & explanation
Correct answer: A full table scan — it checks every row
With no index for the condition, it must read all rows.
Can you get the rest right without peeking?
Take the timed Quiz: Indexing quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →