Microsoft
70-433 · Question #55
You are developing a new database. The database contains two tables named SalesOrderDetail and Product. You need to ensure that all products referenced in the SalesOrderDetail table have a…
The correct answer is C. Foreign key constraint. See the full explanation below for the reasoning.
Question
You are developing a new database. The database contains two tables named SalesOrderDetail and Product. You need to ensure that all products referenced in the SalesOrderDetail table have a corresponding record in the Product table. Which method should you use?
Options
- AJOIN
- BDDL trigger
- CForeign key constraint
- DPrimary key constraint
How the community answered
(50 responses)- A8% (4)
- B16% (8)
- C72% (36)
- D4% (2)
Community Discussion
No community discussion yet for this question.