IBM
C2090-610 · Question #26
A table named STATES was created as follows: What will happen?
The correct answer is B. A warning will be returned and the unique index INDX1 will become the index for the primary key. See the full explanation below for the reasoning.
Question
A table named STATES was created as follows:
What will happen?
Exhibit
Options
- AAn error will be returned and the operation will fail.
- BA warning will be returned and the unique index INDX1 will become the index for the primary key.
- CThe primary key will be successfully added and the unique index INDX1 will be dropped and
- DThe primary key will be successfully added, the unique index INDX1 will be dropped, and a new
How the community answered
(37 responses)- A8% (3)
- B84% (31)
- C5% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.