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:
Correct Answer… B Database trigger – Fires when a particular event occurs in the database.
The events that fire a database trigger
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 triggers
aredeveloped 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. D: You can create an INSTEAD OF trigger on a view and use the trigger to perform DML on a view that is inherently non-updatable.
database triggers = system triggers + dml triggers