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)- A11% (2)
- B83% (15)
- C6% (1)
Community Discussion
No community discussion yet for this question.