Intermediate
Database Management Systems
Q76 / 100
What is a surrogate key?
Correct! Well done.
Incorrect.
The correct answer is C) An artificial, system-generated identifier (such as an auto-incrementing integer or UUID) used as a primary key instead of a natural business attribute
C
Correct Answer
An artificial, system-generated identifier (such as an auto-incrementing integer or UUID) used as a primary key instead of a natural business attribute
Explanation
Surrogate keys (e.g., auto-increment IDs, UUIDs) have no business meaning and remain stable even if real-world attributes change. This avoids problems that arise when natural keys (like email or SSN) are later edited or reused.
Progress
76/100