Database TestingDatabaseIntermediate

Soft delete behavior

Scenario

Your interview prompt

A project management app soft-deletes projects by setting deletedAt and deletedBy instead of removing rows. Deleted projects should disappear from normal lists, remain visible in admin recovery views, and be restorable for 30 days.

What would you test?

List flows, risks, edge cases, data conditions, UX, security, API/backend, and performance concerns.

Tip: a stronger answer usually mixes happy path, negative cases, state changes, data, backend, UX, accessibility, and risk.

How to structure your answer

Happy pathNegative casesData rulesSecurity/API risksUX/performance