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

Quiz: Query Processing and Optimization: questions with answers

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

Take the timed quiz + get a certificate →
  1. Q1. What is the correct order of query processing steps?
  2. Q2. Why does "push selections down" usually make a query faster?
  3. Q3. A table has 20,000 rows and the column dept has 40 distinct values. About how many rows does the optimizer estimate for dept = 'CSE'?
  4. Q4. What does this print? (code)
  5. Q5. Which join algorithm can handle a condition like r.salary < s.limit?
  6. Q6. In SQLite's EXPLAIN QUERY PLAN, what does SCAN students mean?
  7. Q7. Which WHERE clause can use an index on orderdate?
  8. Q8. What does this print? (code)
  9. Q9. Which join method builds an in-memory table on the smaller input and probes it with the larger one?
  10. Q10. Statistics in the catalog are badly out of date after a huge data import. What is the likely effect?