🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← All topics

Quiz: Indexing: questions with answers

10 questions, each with the answer and a short explanation.

Take the timed quiz + get a certificate →
  1. Q1. Without a usable index, how does the database find matching rows?
  2. Q2. How many clustered indexes can a table have?
  3. Q3. An index exists on (city, created). Which query can use it best?
  4. Q4. What is a downside of adding many indexes?
  5. Q5. Which condition usually PREVENTS using an index on created?
  6. Q6. An index exists on (city, created). Can WHERE city = 'Pune' alone use it?
  7. Q7. Which LIKE condition can usually use an index on name?
  8. Q8. Why can a non-clustered index lookup be slower than a clustered one?
  9. Q9. A column isactive has only two values across 1 crore rows. Why may an index on it not help much?
  10. Q10. Which columns get an index automatically in most databases?