nerdexam
IBM

C2090-312 · Question #22

If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?

The correct answer is B. A unique index must be defined on the ROWID column. See the full explanation below for the reasoning.

Question

If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?

Options

  • ANothing because DB2 will control the values.
  • BA unique index must be defined on the ROWID column.
  • CAn identity column must also be created to control uniqueness.
  • DExtra space must be allocated for an overflow area in the table space.

How the community answered

(18 responses)
  • A
    11% (2)
  • B
    83% (15)
  • C
    6% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice