Question:
In a DBMS, a candidate which is not a primary key is called
In a DBMS, a candidate which is not a primary key is called
Show Hint
N/A
Updated On: May 3, 2025
- Super key
- Foreign key
- Alternate key
- Compound key
Hide Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
- Super key: A super key is a set of attributes that uniquely identifies a tuple (record) in a relation. Every primary key is a super key, but not every super key is a primary key.
- Foreign key: A foreign key is an attribute or set of attributes in a table that is used to establish a link between the data in two tables.
- Alternate key: An alternate key is a candidate key that is not selected as the primary key. It is an alternative way to uniquely identify records.
- Compound key: A compound key is a key that consists of two or more attributes to uniquely identify a record.
Therefore, the correct answer is 3. Alternate key.
- Foreign key: A foreign key is an attribute or set of attributes in a table that is used to establish a link between the data in two tables.
- Alternate key: An alternate key is a candidate key that is not selected as the primary key. It is an alternative way to uniquely identify records.
- Compound key: A compound key is a key that consists of two or more attributes to uniquely identify a record.
Therefore, the correct answer is 3. Alternate key.
Was this answer helpful?
0
0
Top Questions on 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
- 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
- The Debentures that are payable on the expiry of the specific period either in lumpsum or in instalments during life time of the company are called:
- CUET (UG) - 2025
- Accountancy
- Database Concepts
- Identify the other name by which Liquid ratio is known:
- CUET (UG) - 2025
- Accountancy
- Database Concepts
Match List I with List II:
Choose the correct answer from the options given below:- CUET (UG) - 2025
- Accountancy
- Database Concepts
View More Questions
Questions Asked in AP PGECET exam
- The absolute humidity of air at 101.325 kPa is measured to be 0.02 kg of water per kg of dry air. Then the partial pressure of water vapour in the air is:
- AP PGECET - 2025
- Thermodynamics
- If the vapour pressure at two temperatures of a solid phase in equilibrium with its liquid phase is known, then the latent heat of fusion can be calculated by the:
- AP PGECET - 2025
- Thermodynamics
- 1 mole of Argon gas is heated at constant pressure from 200 K to 600 K.
If \( C_p = 4\ \text{cal} \cdot \text{deg}^{-1} \cdot \text{mol}^{-1} \), then the change in entropy will be:
(Given \( \ln 3 = 1.09 \))
- AP PGECET - 2025
- Thermodynamics
- The minimum amount of work required to operate a refrigerator which removes 1000 Cal heat at $0^\circ$C and rejects at $50^\circ$C will be:
- AP PGECET - 2025
- Thermodynamics
- The entropy of single crystalline Silicon at absolute zero will be:
- AP PGECET - 2025
- Thermodynamics
View More Questions