Multiple choice technology

_______________ is a substitution for the natural primary key. It is just a unique identifier or number for each row that can be used for the primary key to the table.

  1. candidate key

  2. surrogate key

  3. prerrogate key

  4. identity key

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A surrogate key is an artificial identifier used as a primary key when no natural primary key exists or when the natural key is too complex. It's typically a system-generated unique number for each row, serving as a substitute for natural keys.