Which of the following events will cause the trigger to fire?
AFTER UPDATE OF orderplaced ON bb_basket
A) INSERT
B) UPDATE
C) DELETE
D) AFTER

Question

Quizplus · Accepted Answer

The trigger will fire after an update on the 'orderplaced' column of the 'bb_basket' table. Therefore, the correct choice is UPDATE. INSERT and DELETE will not activate the trigger as they do not involve updating the specified column. AFTER refers to the timing of the trigger, while the trigger will only be activated if the specified event (UPDATE) occurs.

Which of the Following Events Will Cause the Trigger to Fire