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

Which statements are true about database triggers? (Choose all that apply.)

Answer options

• A. They can invoke only PL/SQL procedures.
• B. They can include SQL and PL/SQL or calls to Java procedures.
• C. They are implicitly fired by an event that must occur within an application.
• D. They are implicitly fired when a triggering event occurs, depending on which user is connected.

Correct answer: B, D

Explanation

Option B is correct because database triggers can execute both SQL and PL/SQL, as well as call Java procedures. Option D is also correct since triggers are executed when a specified event occurs, and this can vary depending on the connected user. Options A and C are incorrect as they misrepresent the capabilities and activation conditions of triggers.