Exam 98-364 topic 1 question 187 discussion

Actual exam question from Microsoft's 98-364

Question #: 187
Topic #: 1

What is the relationship between the foreign key and primary key? Each correct answer represents a complete solution. (Choose all that apply.)

A. A foreign key constraint works in conjunction with a primary key constraint to enforce referential integrity among related entities.
B. A foreign key ties attribute(s) of an entity to the primary key of another entity, for the purpose of creating a dependency.
C. There is no relationship between a primary key and a foreign key.
D. A foreign key and a primary key create a link between two entities.

Show Suggested Answer

Suggested Answer: AB 🗳️

by rogeriosolano at June 28, 2022, 11:51 p.m.

Comments

Submit Cancel

rogeriosolano

2 years, 11 months ago

Selected Answer: AB

A foreign key ties attribute(s) of an entity to the primary key of another entity, for the purpose of creating a dependency. It is used to establish and enforce a relationship between data in two tables. A relationship between two tables is created by adding a column or columns holding the primary key values of the primary table to the related table. This column becomes a foreign key in the second table. You can create a foreign key by defining a FOREIGN KEY constraint, when you create or alter a table.

upvoted 1 times

...