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:

Immunization

The process by which a person is made immune or resistant to an infectious disease, typically by the administration of a vaccine.

Informed Consent

A legal and ethical principle requiring that individuals are fully informed about, and understand, the potential risks and benefits before participating in research, medical treatment, or any similar procedure.

Virus

A microscopic infectious agent that can only replicate inside the living cells of an organism, causing various diseases.

Cold Sore Blisters

Small, painful blisters caused by the herpes simplex virus, typically appearing on the lip or around the mouth.