50 questions · 60 minutes · SQL

SQL Final Quiz 3 practice quiz

50 easy MCQs on: tables & columns, constraints (PK/FK/CHECK/NOT NULL/UNIQUE), indexes, DML, transactions, SELECT, WHERE with wildcards, set operators (UNION/INTERSECT/EXCEPT), CASE/NULLs, aggregates (SUM/AVG/COUNT/MAX/MIN), GROUP BY/HAVING, and subqueries.

Before you start

Answer all 50 questions. 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
50
Time
60 minutes
Marks
50
Subject
SQL
Marking
Server-side

What it asks

The first few questions

  1. Which SQL command is used to create a new table?
  2. Which keyword defines the table’s unique identifier?
  3. A FOREIGN KEY is used to:
  4. Which constraint blocks NULL values in a column?

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