Question

In a DBMS, a candidate which is not a primary key is called

• A. Super key
• B. Foreign key
• C. Alternate key
• D. Compound key

Hint:

N/A

Answer 1

The Correct Option is C

- 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.