← Quiz: Checking AI-Written SQL: all 10 questions
Quiz: Checking AI-Written SQL · Question 10 of 10
Before running an AI-written DELETE ... WHERE ... on real data, what should you do?
Before running an AI-written DELETE ... WHERE ... on real data, what should you do?
- A.Nothing, if the query has no syntax errors
- B.Run it twice to be sure
- C.Ask the AI whether it is correct
- D.Run the same WHERE clause as a SELECT to see exactly which rows would be deleted
Answer & explanation
Correct answer: Run the same WHERE clause as a SELECT to see exactly which rows would be deleted
And take a backup, or run it inside a transaction you can roll back.
Can you get the rest right without peeking?
Take the timed Quiz: Checking AI-Written SQL quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →