🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Query Processing and Optimization: all 10 questions

Quiz: Query Processing and Optimization · Question 6 of 10

In SQLite's EXPLAIN QUERY PLAN, what does SCAN students mean?

In SQLite's EXPLAIN QUERY PLAN, what does SCAN students mean?

  1. A.An index on students is used
  2. B.Every row of students is read (full table scan)
  3. C.The table is sorted
  4. D.The query failed
Answer & explanation

Correct answer: Every row of students is read (full table scan)

A SEARCH line with USING INDEX would mean an index lookup.

Can you get the rest right without peeking?

Take the timed Quiz: Query Processing and Optimization quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →