Check sibling questions

An attribute whose value is derived from the primary key of some other table.

(A) Primary key

(B) Foreign key

(C) Alternate key

(D) None of these

 

Answer:

Checking the options

  • (A) Primary key - It is used to uniquely identify the tuples in a relation.
  • (B) Foreign key  - It is used to represent the relationship between two tables/relations.
  • (C) Alternate key - It is a candidate key which has not been selected to be the primary key.
  • (D) None of these 

 

Since a foreign key is used to represent the relationship between 2 tables , it is an attribute whose value is derived from the primary key of another table.

So, the correct answer is (B)

983 students joined Teachoo Black. What are you waiting for?


Transcript

An attribute whose value is derived from the primary key of some other table. (A) Primary key (B) Foreign key (C) Alternate key (D) None of these Checking the options (A) Primary key - It is used to uniquely identify the tuples in a relation. (B) Foreign key - It is used to represent the relationship between two tables/relations. (C) Alternate key - It is a candidate key which has not been selected to be the primary key. (D) None of these Since a foreign key is used to represent the relationship between 2 tables, it is an attribute whose value is derived from the primary key of another table. So, the correct answer is (B)

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.