Which three statements are true regarding database triggers? (Choose three)
A.
A database trigger is a PL/SQL block, C, or Java procedure associated with a table, view,
schema, or the database.
B.
A database trigger needs to be executed explicitly whenever a particular event takes place.
C.
A database trigger executes implicitly whenever a particular event takes place.
D.
A database trigger fires whenever a data event (such as DML) or system event (such as logon,
shutdown) occurs on a schema or database.
E.
With a schema, triggers fire for each event for all users; with a database, triggers fire for each
event for that specific user.
Explanation:
The trigger body is a PL/SQL block in which you can issue both SQL and PL/SQL statements from
the trigger body. You can also call a stored procedure or a Java procedure from the trigger body.
You can also invoke a procedure developed using object-oriented languages, such as C.
C: Triggers are invoked implicitly whenever a particular event occurs in the database.
D: Database Triggers occur when a Data Event DM, DDL occurs or when system events such as
shutting down or starting up the database or a logon or logoff from the database.
Incorrect Answers:
E: Triggers that are created at the database level fire for all the users, and triggers that are created
at the schema level fire only when the triggering event involves that schema.