SQL INSERT, UPDATE & DELETE Quiz

This SQL quiz checks the statements that change data, INSERT, UPDATE and DELETE. You will predict what a table holds after each statement, spot invalid syntax and learn why a missing WHERE is the most expensive typo in SQL.

Easy 10 questions ~5 minutes Pass at 80% SQLite

Choose a mode

Playing as a guest: sign in to keep your XP and streak.

Sample question

Question 1 of 10

What does this print?

CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);
INSERT INTO users (name) VALUES ('Ann'), ('Bob');
INSERT INTO users (name) VALUES ('Cy');
SELECT COUNT(*) FROM users;
Show the answer

A. 3 One INSERT can add several rows by listing several tuples after VALUES, so the first statement adds 2 rows and the second adds 1. The id column is filled in automatically because it is the primary key.

What this quiz covers

  • Inserting one or many rows, with and without a column list
  • Default values for columns you leave out
  • UPDATE with SET and WHERE, and what happens without WHERE
  • DELETE FROM vs dropping a table
  • Copying rows with INSERT ... SELECT

Questions people ask

Do I need an account?

No. Anyone can play. Sign in to keep your XP, streak, badges and history.

Can I retake it?

Yes. Your best score is kept, and the questions and answers are shuffled each time.