35 questions · 40 minutes · SQL
SQL Essentials: Basics to Aggregates (Quiz 3) practice quiz
35-question quiz covering CREATE, INSERT, SELECT, GROUP BY, HAVING, CASE, IF, NULL tests and basic SQL essentials.
Before you start
Read each question carefully. There are 35 questions, 1 mark each. No negative marking. You have 40 minutes.
You can take this without an account and you will still get the full marked review. Only signed-in attempts are saved — sign in first if you want this one kept in your history.
- Questions
- 35
- Time
- 40 minutes
- Marks
- 35
- Subject
- SQL
- Marking
- Server-side
What it asks
The first few questions
- Which SQL statement creates a new table?
- Which clause filters rows after aggregation (e.g., after GROUP BY)?
- Which function returns the total number of rows (including NULLs) in a result set?
- Which clause limits the number of rows returned by a SELECT in MySQL?
31 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.