Changing Data & Database Design Quizzes

Change data safely with INSERT, UPDATE, DELETE and transactions, protect it with constraints and keys, and design tables that stay fast and consistent with indexes and normalization.

Intermediate 5 quizzes · 50 questions about 29 minutes
0/5passed Category exam 20 mixed questions. 80% earns a certificate.
Tags:
1 INSERT, UPDATE & DELETE Easy Add, change and remove rows with INSERT, UPDATE and DELETE, and avoid the classic missing-WHERE mistake. #dml#crud 10 questions · ~5 min Not started Start
2 Constraints & Keys Medium Know what NOT NULL, UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY reject, and how SQLite, MySQL and PostgreSQL differ. #constraints#keys 10 questions · ~6 min Not started Start
3 Transactions & ACID Medium Group changes with BEGIN, COMMIT, ROLLBACK and savepoints, and know what each ACID property promises. #transactions#acid 10 questions · ~6 min Not started Start
4 Indexes Medium Learn what indexes speed up, what they cost and why some queries cannot use them. #indexes#performance 10 questions · ~6 min Not started Start
5 Normalization (1NF, 2NF, 3NF) Medium Spot tables that break 1NF, 2NF or 3NF, the anomalies they cause and how to split them. #design#normalization 10 questions · ~6 min Not started Start