🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.Binary search
  2. B.A full table scan — it checks every row
  3. C.It guesses
  4. 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 →