Question: ________ is the columns of a table that points to the candidate key of another table.

Answer:

In simpler words, a foreign key is a set of attributes that references a candidate key. For example, a table called FOOTBALLTEAM may have an attribute, PLAYER_NAME, which is a foreign key referencing a candidate key, PERSON_NAME, in the PERSON table. Since PLAYER_NAME is a foreign key, any value existing as the name of a member in FOOTBALLTEAM must also exist as a person's name in the PERSON table; in other words, every member of a FOOTBALLTEAM is also a PERSON.

MCQ: ________ is the columns of a table that points to the candidate key of another table.

A. Primary key
B. Super Key
C. Candidate Key
D. Foreign Key

Correct Answer: A. Primary key

Explanation:

In simpler words, a foreign key is a set of attributes that references a candidate key. For example, a table called FOOTBALLTEAM may have an attribute, PLAYER_NAME, which is a foreign key referencing a candidate key, PERSON_NAME, in the PERSON table. Since PLAYER_NAME is a foreign key, any value existing as the name of a member in FOOTBALLTEAM must also exist as a person's name in the PERSON table; in other words, every member of a FOOTBALLTEAM is also a PERSON.