Question

Which of the following is an SQL trigger Oracle supports?

1) BEFORE
2) INSTEAD OF
3) AFTER
4) B and C only
5) A, B, and C

Answer 1

The SQL triggers that Oracle supports include BEFORE, INSTEAD OF, and AFTER. These are used to perform automated tasks in response to insert, update, or delete operations on a table or view. Option 5) A, B, and C is the correct answer.

Step-by-step explanation:

Oracle's Structured Query Language (SQL) supports various types of triggers, which are a special kind of stored procedure that automatically executes in response to certain events on a particular table or view in a database. The types of triggers that Oracle supports include BEFORE, INSTEAD OF, and AFTER. Therefore, the correct answer to which SQL trigger Oracle supports is option 5) A, B, and C. A BEFORE trigger runs before an insert, update, or delete operation on a table. An INSTEAD OF trigger is used mainly for views, where it can provide a way to update a view that cannot be updated through a simple insert or update operation. An AFTER trigger executes after the insert, update, or delete operation is completed. By using triggers, automated tasks can be set up to enforce complex business rules at the database level.