Question
Computer Science Question on Database Concepts
| How many candidate keys are possible with the table?RollNo | Name | Mobile | City |
|---|---|---|---|
| 1 | Arun | 91 | Delhi |
| 2 | Sanjay | 92 | Mumbai |
| 3 | Arun | 93 | Noida |
| 4 | Varun | 94 | Guwahati |
| 5 | Arti | 95 | Kolkata |
A
One
B
Two
C
Three
D
Four
Answer
Two
Explanation
Solution
The ‘RollNo’ and ‘Mobile’ columns can serve as candidate keys due to their uniqueness for each student in the table.