Question 5 - MCQ questions - Chapter 8 - Database Concepts

Last updated at July 14, 2026 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)

Remove Ads
Teachoo · Class 12 Explore Class 12

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 is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.