What is an alternate key?
A) foreign key
B) primary key
C) column that could be a primary key but was not chosen
D) row that could be a primary key but was not chosen

Question

Quizplus · Accepted Answer

An alternate key is a column or combination of columns that could be chosen as the primary key, but for some reason, such as preference, simplicity, or practicability, a different column or combination of columns was selected as the primary key. Therefore, option C, "column that could be a primary key but was not chosen" is the correct answer. Option A, a foreign key, is a column or combination of columns in one table that refers to the primary key of another table. Option B, a primary key, is a column or combination of columns that uniquely identifies each row in a table. Option D, a row that could be a primary key but was not chosen, is not a valid concept since a primary key refers to a column or combination of columns within a table, not to a row.

What Is an Alternate Key