50 questions · 60 minutes · SQL

SQL Final Quiz 2 practice quiz

50 easy MCQs strictly from syllabus: tables/columns, constraints, indexes, DML, transactions, SELECT/WHERE/ORDER BY, LIKE, set operators, CASE/NULLs, aggregates+GROUP BY/HAVING, subqueries, views.

Before you start

Read carefully. 50 questions, 1 mark each. No negative marking. 60 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
50
Time
60 minutes
Marks
50
Subject
SQL
Marking
Server-side

What it asks

The first few questions

  1. Which command creates a new table?
  2. Which clause removes a table permanently?
  3. How do you add a new column to an existing table t?
  4. Which type stores variable-length character data?

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