The UNIQUE Constraint Differs from the PRIMARY KEY Constraint in What

question 47

Multiple Choice

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?

• A) The UNIQUE constraint does not allow NULL values.
• B) The UNIQUE constraint can be created at either the column level or the table level.
• C) The UNIQUE constraint allows NULL values.
• D) The UNIQUE constraint ensures that a specific condition is True before a data value is added to a table.

---

Definitions:

Rock Springs

A location known for the Rock Springs Massacre, an 1885 riot against Chinese immigrant miners in Rock Springs, Wyoming, highlighting racial tensions in the American West.

Wyoming

A U.S. state known for its vast plains and Rocky Mountain ranges, became the first state to grant women the right to vote in 1869.

Race Riot

Refers to a public outbreak of violence between racial groups in a community, often reflecting underlying social tensions.

Chinese Miners

Refers to miners of Chinese origin, historically significant in various mining operations globally, particularly during gold rushes in countries like the United States, Australia, and Canada.