An artificial column added to a relation to serve as the primary key is a ________.
A)composite key
B)candidate key
C)foreign key
D)surrogate key

Question

Quizplus · Accepted Answer

The artificial column added to a relation to serve as the primary key is called a surrogate key. It is typically an auto-generated value that has no intrinsic meaning but serves as a unique identifier for each row in the table. Composite keys are made up of multiple columns, candidate keys are potential primary keys, and foreign keys relate to another table's primary key.

An Artificial Column Added to a Relation to Serve as the Primary