Candidate Key | MCQs

Explanation

An Alternate key is any candidate key not chosen as the primary key.

It can still uniquely identify records, but isn't used as the main identifier.

Explanation

DBMS Keys: 

Primary Key: A primary is a column or set of columns in a table that uniquely identifies tuples (rows) in that table.

Super Key: A superkey is a set of one or more columns (attributes) to uniquely identify rows in a table.

Candidate Key: A super key with no redundant attribute is known as a candidate key

*********

ND03-12-2022