Database Keys | MCQs

Explanation

A foreign key is used to link two tables and can contain duplicate values.

In contrast, primary, candidate, and even secondary keys are typically unique.

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