IBM
C2090-312 · Question #166
Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?
The correct answer is B. Use the ALTER INDEX statement to add a column to an index that was built with DEFINE NO. See the full explanation below for the reasoning.
Question
Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?
Options
- AIssue the ALTER INDEX REGENERATE statement.
- BUse the ALTER INDEX statement to add a column to an index that was built with DEFINE NO.
- CAdd a new column to both a table and an index in the same commit operation when the table is in
- DWhen you extend the length of a varying-length character (VARCHAR data type) or varying-
How the community answered
(54 responses)- A7% (4)
- B78% (42)
- C11% (6)
- D4% (2)
Community Discussion
No community discussion yet for this question.