Microsoft
MB6-890 · Question #14
A relationship is defined between two tables named CustTable and CustGroup. Each record in CustTable references a record in CustGroup. You need to set up delete actions to ensure that records in…
The correct answer is C. Restricted. See the full explanation below for the reasoning.
Question
A relationship is defined between two tables named CustTable and CustGroup. Each record in CustTable references a record in CustGroup. You need to set up delete actions to ensure that records in CustGroup can only be deleted if there are no CustTable records that reference or relate to the record. Which values for the On Delete property for the relation should you specify?
Options
- ANone
- BCascade + Restricted
- CRestricted
- DCascade
How the community answered
(27 responses)- A11% (3)
- B4% (1)
- C78% (21)
- D7% (2)
Community Discussion
No community discussion yet for this question.