Check sibling questions

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)

Are ads bothering you?


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 - 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.