A ________ is the primary key of one table stored in a second table to allow a relation to be created.
A) foreign key
B) composite key
C) unique key
D) natural key

Question

Quizplus · Accepted Answer

A foreign key is used to create a relationship between two tables by referencing the primary key of one table in a second table. This allows for more efficient and effective data management and retrieval.

B, C, and D are incorrect. A composite key is a combination of two or more columns used as a primary key, a unique key is used to ensure that a column or group of columns has unique values, and a natural key is a type of unique key that uses a naturally occurring identifier, such as a Social Security number or email address. While these keys may be used in database design, they are not specifically related to creating a relationship between two tables.

A ________ Is the Primary Key of One Table Stored