Which statement about triggers is true?
A.
You use an application trigger to fire when a DELETE statement occurs.
B.
You use a database trigger to fire when an INSERT statement occurs.
C.
You use a system event trigger to fire when an UPDATE statement occurs.
D.
You use INSTEAD OF trigger to fire when a SELECT statement occurs.
Explanation:
are Data events and System events. Data events consist of DML statements (INSERT, UPDATE
& DELETE) and DDL statements, such as CREATE or DROP . System Events Comprised of
actions that are performed either at the schema level or database level.
Incorrect Answers:
A: An Application trigger fires when a particular event occurs in the application. Application
triggersare developed using Oracle client-side tools, such as Oracle Forms Developer.C. The
events that cause triggers created on system events to fire are: DDL statement on an object,Users
logging on or off the database, Database shutdown or startup & Server errors.