IBM
C2090-600 · Question #65
What is the result of the following scenario?
The correct answer is B. The row is updated to (2, 110.00). See the full explanation below for the reasoning.
Question
What is the result of the following scenario?
Exhibit
Options
- AThe row is updated to (2, NULL)
- BThe row is updated to (2, 110.00)
- CSQL0407N Assignment of a NULL value to a NOT NULL column is not allowed
- DThe CREATE TRIGGER statement will fail because amt is defined as NOT NULL
How the community answered
(40 responses)- A8% (3)
- B70% (28)
- C18% (7)
- D5% (2)
Community Discussion
No community discussion yet for this question.