Question:medium

How many candidate keys are possible with the table?
RollNoNameMobileCity
1Arun91Delhi
2Sanjay92Mumbai
3Arun93Noida
4Varun94Guwahati
5Arti95Kolkata

Updated On: Jan 16, 2026
  • One
  • Two
  • Three
  • Four
Show Solution

The Correct Option is B

Solution and Explanation

The objective is to determine the count of candidate keys within the presented table. A candidate key is defined as the smallest collection of attributes capable of uniquely identifying a record in a table. Analyzing the table:

RollNoNameMobileCity
1Arun91Delhi
2Sanjay92Mumbai
3Arun93Noida
4Varun94Guwahati
5Arti95Kolkata

'RollNo' is unique for each student, thus qualifying as a candidate key.

'Mobile' numbers are also unique, making them a candidate key as well.

Based on this evaluation, there are two candidate keys: 'RollNo' and 'Mobile'.

Consequently, the answer is: Two.

Was this answer helpful?
0


Questions Asked in CUET (UG) exam