Microsoft
98-364 · Question #197
You have a Department table and an Employee table in your database. You need to ensure that an employee can be assigned to only an existing department. What should you apply to the Employee table?
The correct answer is C. a foreign key. See the full explanation below for the reasoning.
Question
You have a Department table and an Employee table in your database. You need to ensure that an employee can be assigned to only an existing department. What should you apply to the Employee table?
Options
- Aa primary key
- Ban index
- Ca foreign key
- Da unique constraint
- Ea data type
How the community answered
(41 responses)- A7% (3)
- B2% (1)
- C83% (34)
- D5% (2)
- E2% (1)
Community Discussion
No community discussion yet for this question.