Question 5 - MCQ questions - Chapter 8 - Database Concepts

Last updated at April 16, 2024 by

The attributes which have all the properties of primary key

(A) Foreign key

(B) Alternate key

(C) Candidate key

(D) Both (a) and (c)

 

Answer:

A primary key is an attribute which can uniquely identify the records in a relation/table.

Checking the options

  • (A) Foreign key - It is an attribute used to represent the relationship between two tables/relations.
  • (B) Alternate key  - It is a candidate key which has not been selected to be the primary key.
  • (C) Candidate key -   refers to the set of all attributes which can uniquely identify records in a relation.
  • (D) Both (a) and (c)  

Since candidate keys can also uniquely identify records in a relation, it has similar properties to primary Key.

So, the correct answer is (C)

Go Ad-free

Transcript

The attributes which have all the properties of primary key (A) Foreign key (B) Alternate key (C) Candidate key (D) Both (a) and (c) A primary key is an attribute which can uniquely identify the records in a relation/table. Checking the options (A) Foreign key - It is an attribute used to represent the relationship between two tables/relations. (B) Alternate key - It is a candidate key which has not been selected to be the primary key. (C) Candidate key - refers to the set of all attributes which can uniquely identify records in a relation. (D) Both (a) and (c) Since candidate keys can also uniquely identify records in a relation, it has similar properties to primary Key. So, the correct answer is (C)

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 and Computer Science at Teachoo