MCQ questions

Computer Science - Class 12
Chapter 8 - Database Concepts

## (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)

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

### 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)

Made by

#### Davneet Singh

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