Question

A foreign key is a column in one table that references a primary key in another table? (true/false)

Answer 1

Answer:

The correct answer for the given question is "true"

Explanation:

A foreign key is a column in one table which value must match be the primary key in another table.The forign key provide a linking between the two table.

Suppose we have two table customer  and order

customer  table:

 C_ID Name  Age

  1          rahul             30

  2         sumit           23

order table:

  C_ID o_id     ordernum

  1            123           13044

  2          1234          13045

C_ID column is the PRIMARY KEY  in the customer table

C_ID column is the FOREIGN KEY  in the Order  table

Because the value of C_ID column in order table is matched with PRIMARY KEY table i.e :customer table.So the answer is true .