A surrogate key may be appropriate under which of the following circumstances?
A) The primary key is not unique.
B) The primary key is numeric.
C) The available candidate keys would be prone to typographical errors.
D) The available candidate keys have little meaning to the users.
E) The relation only has one attribute.

Question

Quizplus · Accepted Answer

A surrogate key is often used when the available candidate keys are prone to typographical errors, as it provides a unique, system-generated identifier that is less likely to be entered incorrectly.

A Surrogate Key May Be Appropriate Under Which of the Following