To ensure the uniqueness of values in a nonprimary key column,use the ____ command to create an index.
A)CREATE UNIQUE INDEX
B)CREATE NONPRIMARY INDEX
C)CREATE INDEX
D)CREATE ONLY INDEX

Question

To ensure the uniqueness of values in a nonprimary key column,use the ____ command to create an index.​
A)CREATE UNIQUE INDEX
B)​CREATE NONPRIMARY INDEX
C)CREATE INDEX
D)​CREATE ONLY INDEX

Quizplus · Accepted Answer

This command creates an index that enforces uniqueness on the indexed column. Thus, it ensures that no two rows can have the same value in that column, preventing duplicates. It is the best choice for ensuring uniqueness in a nonprimary key column.

To Ensure the Uniqueness of Values in a Nonprimary Key