An alternative to the primary key of a table is listed with which abbreviation in DBDL?
A) SK
B) FK
C) PK
D) AK

Question

Quizplus · Accepted Answer

AK refers to an alternative key, which is a candidate key other than the primary key of a table. SK refers to a surrogate key, which is an artificially generated key used as a substitute for a natural primary key. FK refers to a foreign key, which is a column or combination of columns in one table that refers to the primary key of another table. PK refers to the primary key of a table. Since we are looking for an alternative key to the primary key, the best choice is D - AK.

An Alternative to the Primary Key of a Table Is