IBM
C2090-610 · Question #24
Which statement is true about an index that is used to support a UNIQUE constraint?
The correct answer is C. It must be defined with the UNIQUE attribute. See the full explanation below for the reasoning.
Question
Which statement is true about an index that is used to support a UNIQUE constraint?
Options
- AIt must not contain more than one column.
- BIt cannot be used in a referential constraint.
- CIt must be defined with the UNIQUE attribute.
- DIt must be defined as UNIQUE WHERE NOT NULL.
How the community answered
(43 responses)- A2% (1)
- B12% (5)
- C79% (34)
- D7% (3)
Community Discussion
No community discussion yet for this question.