nerdexam
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)
  • A
    7% (4)
  • B
    78% (42)
  • C
    11% (6)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice