3384. Restore: Restore the newest deleted customer matching an email. — Security

DBMS Published 30 Sept 2026 Updated 30 Sept 2026 0 Views Verified

In a restore module, solve this as a production problem using Security: Restore the newest deleted customer matching an email. Provide the SQL, explain the logic, show safe application integration, and mention failure/edge cases.

Looking for the latest Sarkari Result 2026 updates? Check the latest government exam results, merit lists and result updates on Sarkari Resultess.

Answer & Explanation

4 Answers

Verified

Option A

SELECT * FROM table_name;

Additional Explanation

Incorrect: it does not satisfy the stated business rule and can return/change unintended data.

Verified

Option B

UPDATE table_name SET status='active';

Additional Explanation

Incorrect: it does not satisfy the stated business rule and can return/change unintended data.

Verified

Option C

DELETE FROM table_name;

Additional Explanation

Incorrect: it does not satisfy the stated business rule and can return/change unintended data.

Verified Correct Answer

Option D

UPDATE customers c JOIN (SELECT id FROM customers WHERE email=:email AND deleted_at IS NOT NULL ORDER BY deleted_at DESC LIMIT 1) x ON x.id=c.id SET c.deleted_at=NULL,c.status='active';

Additional Explanation

The subquery identifies one target row before restoring it.