How do you specify that a trigger should only fire if the value of the column AMOUNT is less than 100?
A)IF amount

Question

How do you specify that a trigger should only fire if the value of the column AMOUNT is less than 100?
A)IF amount < 100
B)WHEN amount < 100
C)ONLY IF amount < 100
D)ONLY WHEN amount < 100

Quizplus · Accepted Answer

The correct syntax to specify a condition for a trigger to fire in many SQL dialects is to use "WHEN" followed by the condition. In this case, "WHEN amount < 100" specifies that the trigger should only fire if the value of the column AMOUNT is less than 100.

How Do You Specify That a Trigger Should Only Fire