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)


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)

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.