Question:
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
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 |
Updated On: Mar 29, 2025
- One
- Two
- Three
- Four
Hide Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
A candidate key is a minimal set of attributes that uniquely identifies each tuple in a table.
In the given table:
Therefore, the candidate keys are RollNo and Mobile.
Thus, the answer is (2) Two.
Was this answer helpful?
0
0
Top Questions on Database Concepts
- Consider the following database schema: \[ \text{Person (aadhar CHAR(12) PK, name VARCHAR(32))} \] \[ \text{Customer (name VARCHAR(32), email VARCHAR(32) PK, phone CHAR, aadhar CHAR(12) FK(aadhar))} \] Which of the following statements is/are correct?
- GATE DA - 2025
- Data Science and Artificial Intelligence
- Database Concepts
- Given the relation: \[ R = \{A, B, C, D, E, F, G\} \] With the following functional dependencies (FDs): \[ A \rightarrow BCEF, \quad E \rightarrow DG, \quad BC \rightarrow A \] Which of the following statements is correct?
- GATE DA - 2025
- Data Science and Artificial Intelligence
- Database Concepts
- An alternate key is ________.
- CUET (UG) - 2024
- Computer Science
- Database Concepts
- A relation in a relational database is also known as:
- CUET (UG) - 2024
- Computer Science
- Database Concepts
- A domain in a relational database refers to:
- CUET (UG) - 2024
- Computer Science
- Database Concepts
View More Questions
Questions Asked in CUET exam
- Match the words in List-I with their definitions in List-II :
List-I (Words) List-II (Definitions) (A) Theocracy (I) One who keeps drugs for sale and puts up prescriptions (B) Megalomania (II) One who collects and studies objects or artistic works from the distant past (C) Apothecary (III) A government by divine guidance or religious leaders (D) Antiquarian (IV) A morbid delusion of one’s power, importance or godliness Choose the correct answer from the options given below :- CUET (UG) - 2024
- Vocabulary
- Identify the correct sequence of the Selection process:
(A) Selection decision
(B) Employment interview
(C) Selection tests
(D) Reference checking- CUET (UG) - 2024
- Staffing
- If \(\tan^{-1}\left(\frac{2}{3 - x + 1}\right) = \cot^{-1}\left(\frac{3}{3x + 1}\right)\), then which one of the following is true?
- CUET (UG) - 2024
- Inverse Trigonometric Functions
- If $\sin A = \frac{4}{5}$, then $(3 − \tan A)(2 + \cos A)$ is:
- CUET (UG) - 2024
- Trigonometry
- The corner points of the feasible region determined by $x + y \leq 8$, $2x + y \geq 8$, $x \geq 0$, $y \geq 0$ are $A(0, 8)$, $B(4, 0)$, and $C(8, 0)$. If the objective function $Z = ax + by$ has its maximum value on the line segment $AB$, then the relation between $a$ and $b$ is:
- CUET (UG) - 2024
- Linear Programmig Problem
View More Questions