Computer Science - Database Systems - SQL - INSERT, UPDATE, DELETE - SQL Safety Quiz
8 questions. Q1: What's dangerous about 'DELETE FROM students'? → Deletes ALL rows (no WHERE clause). Q2: How to safely test an UPDATE? → Run the WHERE clause with SELECT first. Q3: INSERT INTO students VALUES (1, 'X', 15, 10, 90) - what's the risk? → Column order must match exactly; fragile if sche