← 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 →- Q1. What is the correct order of query processing steps?
- Q2. Why does "push selections down" usually make a query faster?
- 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'?
- Q4. What does this print? (code)
- Q5. Which join algorithm can handle a condition like r.salary < s.limit?
- Q6. In SQLite's EXPLAIN QUERY PLAN, what does SCAN students mean?
- Q7. Which WHERE clause can use an index on orderdate?
- Q8. What does this print? (code)
- Q9. Which join method builds an in-memory table on the smaller input and probes it with the larger one?
- Q10. Statistics in the catalog are badly out of date after a huge data import. What is the likely effect?