20 questions · 30 minutes · SQL

SQL Basics Practice quiz 1 practice quiz

20 simple questions on CREATE DATABASE, CREATE TABLE, INSERT, basic SELECT 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. What is the SQL command to create a new database named shop_db?
  2. Which statement creates a table "users" with an integer id column and a name column?
  3. Which command adds a new row into the products table?
  4. How do you list all columns from a table orders?

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