🎙 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 5 of 10

Which condition usually PREVENTS using an index on created?

Which condition usually PREVENTS using an index on created?

  1. A.created = '2026-11-01'
  2. B.created BETWEEN '2026-01-01' AND '2026-12-31'
  3. C.YEAR(created) = 2026
  4. D.created > '2026-01-01'
Answer & explanation

Correct answer: YEAR(created) = 2026

Wrapping the column in a function hides the sorted values from the index.

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 →