Which statements are true about database triggers? (Choose all that apply.)
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
Did the question meant Database-event Triggers? then the correct response will be different right?
mean*
agree with Paul, only B
B,D
In my opinion correct answer B
A is not correct: “A trigger stored in the database can include SQL and PL/SQL or Java statements to run ”
C is not correct: “You can write triggers that fire whenever one of the following operations occurs:
DML statements (INSERT, UPDATE, DELETE) on a particular table or view, issued by any user
DDL statements (CREATE or ALTER primarily) issued either by a particular schema/user or by any schema/user in the database
Database events, such as logon/logoff, errors, or startup/shutdown, also issued either by a particular schema/user or by any schema/user in the database”
So event don’t have to occur within an application
D is not correct: “Triggers are implicitly fired by Oracle Database when a triggering event occurs, NO matter which user is connected or which application is being used.”
Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28318/triggers.htm#CNCPT1686