Microsoft
98-364 · Question #220
You have two tables named Salesperson and Sales. You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table. Which database object…
The correct answer is C. Foreign key. See the full explanation below for the reasoning.
Question
You have two tables named Salesperson and Sales. You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table. Which database object should you add to the Sales table?
Options
- ANonclustered index
- BPrimary key
- CForeign key
- DClustered index
How the community answered
(41 responses)- A17% (7)
- B2% (1)
- C71% (29)
- D10% (4)
Community Discussion
No community discussion yet for this question.