← All topics
Quiz: Filtering and Sorting: questions with answers
10 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. Which finds names that START with "R"?
- Q2. What does WHERE deptid = NULL return?
- Q3. salary BETWEEN 40000 AND 60000 includes a salary of 60000?
- Q4. Which removes duplicate values from the result?
- Q5. In WHERE city = 'Pune' OR city = 'Delhi' AND salary 50000, which is evaluated first?
- Q6. Using the company employees table, how many rows does WHERE name LIKE 'e%' return?
- Q7. How many rows does SELECT name FROM employees WHERE deptid < 10 return for the company table?
- Q8. What does COALESCE(deptid, 0) give for an employee whose deptid is NULL?
- Q9. With the CASE in this lesson (= 80000 Senior, = 50000 Mid, else Junior), what band does a salary of exactly 50000 get?
- Q10. What does ORDER BY salary DESC, name ASC do when two employees have the same salary?