IBM
C2090-312 · Question #32
A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The…
The correct answer is D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4). See the full explanation below for the reasoning.
Question
A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?
Options
- AAdd a new index on COL4.
- BPerform a ALTER INDEX IX1 ADD COLUMN (COL4).
- CAdd a new UNIQUE index on COL1, COL2, COL3, COL4.
- DPerform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).
How the community answered
(23 responses)- A4% (1)
- B4% (1)
- C9% (2)
- D83% (19)
Community Discussion
No community discussion yet for this question.