In a master-detail relationship, what happens to the related detail records when someone deletes the master record?
- The system blocks the delete until the admin manually removes every related detail record.
- The detail records are automatically moved to a default master record chosen by the admin.
- All related detail records are automatically cascade-deleted along with the master record, and both master and detail records are placed in the Recycle Bin.
- The detail records stay in the system as unrelated, orphaned records with a blank relationship field.
Show answer
Answer: C
Why: Master-detail relationships bind children tightly to their parent. Deleting the master cascade-deletes every detail record, and all of them go to the Recycle Bin, where restoring the master brings the details back too. Lookup relationships behave differently: the child survives with an empty parent field.