IBM Exam Questions

What is the result of the following scenario?

What is the result of the following scenario?

A.
The row is updated to (2, NULL)

B.
The row is updated to (2, 110.00)

C.
SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed

D.
The CREATE TRIGGER statement will fail because amt is defined as NOT NULL