INSERT, UPDATE, DELETE Statements: Interview

How do you make an UPDATE or DELETE safe in production?

First express and verify the target rows with SELECT, execute the write inside a transaction, inspect the affected-row count, and commit only when the predicate and result are correct.

Call out missing WHERE clauses, constraints, audit requirements, and rollback strategy.