20 questions · 30 minutes · SQL
SQL Basics Practice quiz 3 practice quiz
20 more simple questions focused on CREATE, INSERT, SELECT, WHERE, CASE and simple clauses.
Before you start
20 MCQs. 1 mark each. No negative marking.
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
- 20
- Time
- 30 minutes
- Marks
- 20
- Subject
- SQL
- Marking
- Server-side
What it asks
The first few questions
- Which SQL command sets the storage engine and charset while creating a table (MySQL example)?
- Which command inserts a row and sets values for only some columns?
- Which clause would you use to change order to newest first based on created_at?
- Which SELECT uses an alias for table t as x to simplify references?
16 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.