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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
I think correct answers are 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.