20 questions · 30 minutes · SQL

SQL Basics Practice quiz 2 practice quiz

20 simple questions on CREATE, INSERT, SELECT, basic conditions and CASE logic.

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

  1. Which statement creates a database user named dbuser (generic example)?
  2. How do you select only the "name" column from table employees?
  3. Which clause would you use to rename a column in a SELECT result?
  4. Which keyword prevents duplicate rows in SELECT results?

16 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.