In the second table of two related tables, the common field shared with the first table is called the ____ key.
A) foreign
B) primary
C) secondary
D) master

Question

Quizplus · Accepted Answer

In a database, when two tables are related, the common field that is present in both tables is called the foreign key in the second table. This foreign key establishes a relationship with the primary key of the first table. Therefore, option A is the correct choice. Option B (primary) refers to the common field in the first table which is used to establish the relationship with the foreign key in the second table. Option C (secondary) and option D (master) are not relevant to the context of the question.

In the Second Table of Two Related Tables, the Common