Databases · Junior · Question 36 of 75
What is a 'soft delete'?
- 1Deleting a row only from the cache
- ✓Correct answer: Marking a row as deleted (e.g.
deleted_attimestamp) instead of removing it - 3Deleting a row slowly to reduce load
Explanation
It allows restoring data and keeps history, but every query must filter out deleted rows, and unique constraints need care (for example, a partial unique index).