Which two statements are true about statement-level and row-level triggers? (Choose two.)
A.
A row trigger fires once even if no rows are affected.
B.
A statement trigger fires once even if no rows are affected.
C.
Row triggers are useful if the trigger action depends on the data of rows that are affected or on
data that is provided by the triggering event itself.
D.
Statement triggers are useful if the trigger action depends on the data of rows that are affected
or on data that is provided by the triggering event itself.
B, C
B,C
b,c
BC
B,C
Imagine you have a 1M rows table and you run:
UPDATE t SET columnX = columnX + 1
A statement-level trigger will be activated once (and even if no rows are updated). A row-level trigger will be activated a million times, once for every updated row.