Roy's AI LabData Analytics
SQL Interview Practice
Practise SQL with multiple-choice questions in the style used in technical screening. Every answer comes with an explanation.
Free sets
Pro sets
Sample questions
1. Which query returns only the distinct departments from the employees table?
- A. SELECT DISTINCT department FROM employees;
- B. SELECT UNIQUE department FROM employees;
- C. SELECT department FROM employees GROUP department;
- D. SELECT department DISTINCT FROM employees;
2. Which condition returns rows where manager_id is missing?
- A. WHERE manager_id = NULL
- B. WHERE manager_id IS NULL
- C. WHERE manager_id == NULL
- D. WHERE NULL(manager_id)
Answers and explanations appear after you submit the full free set.