Question

A...............................key is a field or set of fields that is used to establish a relation

between the two tables.

a) Primary Key

b) Candidate Key

c) Foreign Key

d) None of these​

Answer 1

Answer:

c) Foreign key.

Explanation:

Let say u have 2 tables.

table 1 columns : rollno , name

table 2 columns : name , marks.

let say both the table have foreign key relation with column "name.", so it will help u to get an output of you want to make a relation between rollno and marks.

it's not mandatory that foreign key column name should be same for both the tables, it can be different. like table 2 columns can be : full name ,marks. In this case you need to compare the value between name and full name column.