Oracle Database 11g: Program with PL/SQL — Question 67

Which two statements are true about statement-level and row-level triggers? (Choose two.)

Answer options

• 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.

Correct answer: B, C

Explanation

Option B is correct because statement triggers execute once per triggering event, regardless of the number of rows affected. Option C is also correct as row triggers are specifically designed to act based on the data of the affected rows. Options A and D are incorrect; A is wrong because row triggers do not fire if no rows are affected, and D is incorrect because statement triggers do not depend on the data of affected rows.