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.
Answer: B,C
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.
B, C
B,C
b,c
http://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj43125.html
statement triggers
A statement trigger fires once per triggering event and regardless of whether any rows are modified by the insert, update, or delete event.
row triggers
A row trigger fires once for each row affected by the triggering event. If no rows are affected, the trigger does not fire.