A Surrogate Key May Be Appropriate Under Which of the Following

question 32

Multiple Choice

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.

---

Definitions:

Creative

The ability to think of new and original ideas; characterized by innovation and imagination.

Tend-And-Befriend Response

A behavioral response to stress that involves seeking social support and nurturing others, as opposed to fight-or-flight reactions.

Stressful Situation

Circumstances or events that cause a significant amount of stress, anxiety, or discomfort in individuals.

Affiliation-Related Behaviors

Actions and conduct associated with establishing and maintaining social connections with others.