Microsoft
MB2-707 · Question #94
You have a new entity named Car. You create an N:l relationship between Car and the Contact entity. You configure this relationship with the Referential, Restrict Delete type. A Contact named Daisy…
The correct answer is C. Daisy Lawrence, Car1 and Car2 are not deleted, and an error is generated. https://technet.microsoft.com/en-us/library/dn531171.aspx
Manage Relationships
Question
You have a new entity named Car. You create an N:l relationship between Car and the Contact entity. You configure this relationship with the Referential, Restrict Delete type. A Contact named Daisy Lawrence has two Cars, Carl and Car2. You delete the contact. What is the result?
Options
- ADaisy Lawrence is deleted, and Car1 and Car2 generate a warning about references.
- BDaisy Lawrence, Carl1 and Car2 are deleted during the cascading delete operation.
- CDaisy Lawrence, Car1 and Car2 are not deleted, and an error is generated.
- DDaisy Lawrence is deleted, and Carl and Car2 are not deleted.
How the community answered
(44 responses)- A2% (1)
- B7% (3)
- C80% (35)
- D11% (5)
Explanation
Topics
#referential restrict delete#cascade behavior#N:1 relationship#delete operation
Community Discussion
No community discussion yet for this question.