Oracle PLSQL Suppose that the following DML triggers have be

Oracle PL/SQL

Suppose that the following DML triggers have been defined on the above EMPLOYEES table:

       -- a   BEFORE INSERT statement trigger

       -- a   BEFORE UPDATE statement trigger

       -- an AFTER DELETE statement trigger

An UPDATE statement updates three employee rows.    How many times will each trigger fire?

Solution

For Every time when we update any Row Once the Trigger Will be Fired.

Hence when we will Write update Three Different Times it will be fired Thrice

And if In Only one statement Three Rows Are Updated Then it will be fired only Once.

Hence the result is One Since in one statement the Three Rows are updated