Multiple choice

Which of the following is not true about indexes?

  1. Indexes are created to enforce uniqueness on columns.

  2. Indexes are created to enable fast retrieval by column values.

  3. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

  4. Indexes are created with the ALTER TABLE command.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The correct answer is D because indexes are created using the CREATE INDEX command, not ALTER TABLE. Options A, B, and C are all true statements about indexes: they can enforce uniqueness (A), enable fast retrieval by column values (B), and columns frequently used in WHERE clauses are indeed good candidates for indexing (C).

Keep practicing — related questions