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