A _____ is a primary key created by a database designer to simplify the identification of entity instances.
A) composite key
B) compound key
C) natural key
D) surrogate key

Question

Quizplus · Accepted Answer

Surrogate key is a primary key created by a database designer to simplify the identification of entity instances. It is usually a sequentially generated number or an auto-incremented value, which does not have any logical relationship with the data within the entity. It is a widely used practice, as it helps in maintaining the uniqueness and integrity of the primary key and avoids any potential issues related to updates or changes in the natural key.

A _____ Is a Primary Key Created by a Database