Question:
An alternate key is ________.
An alternate key is ________.
Updated On: Mar 29, 2025
- Another name for the primary key
- A unique identifier besides the primary key
- A relationship between two tables
- A synonym for a tuple
Hide Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
An alternate key is a unique identifier besides the primary key.
Additional Context:
- Candidate key not selected as primary key
- Still maintains uniqueness constraint
- Example: In students table:
- Primary Key: student_id
- Alternate Key: email or roll_number
Correct Answer: (2) A unique identifier besides the primary key.
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
- 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
- What is the primary difference between a database and a file system?
- CUET (UG) - 2024
- Computer Science
- Database Concepts
View More Questions
Questions Asked in CUET exam
- Two large plane parallel sheets shown in the figure have equal but opposite surface charge densities \(+\sigma\) and \(-\sigma\). A point charge q placed at points \(P_1,P_2,P_3\) experiences forces \(\overrightarrow{F_1},\overrightarrow{F_2},\overrightarrow{F_3}\) respectively. Then,
- CUET (UG) - 2024
- Electrostatics
- A, B, and C are partners sharing profits in the ratio of 3:3:4. They decide to share future profits equally. The sacrifice or gain of partners are
- CUET (UG) - 2024
- Reconstitution of Partnership
- Two pipes A and B together can fill a tank in 40 minutes. Pipe A is twice as fast as pipe B. Pipe A alone can fill the tank in:
- CUET (UG) - 2024
- Time and Work
- Radiation of frequency \(2ν_0\) is incident on a metal with threshold frequency \(ν_0\). The correct statement of the following is ______.
- CUET (UG) - 2024
- Dual nature of matter
- On the date of admission of a partner, there was a balance of ₹45,000 in the account of machinery. It was found undervalued by 10%. The value of machinery will appear in the new Balance Sheet at
- CUET (UG) - 2024
- Reconstitution of Partnership
View More Questions