Question 4 - MCQ questions - Chapter 8 - Database Concepts

Last updated at April 16, 2024 by

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)

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)

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.