The trigger is the procedure which is implicitly executed by the Oracle server when the INSERT, UPDATE, DELETE statement is executed against the associated table in the Oracle database.

 

Based on the event these are the types of trigger:-

  • DDL Trigger:-INSERT/UPDATE/DELETE
  • DML Trigger:-CREATE/ALTER
  • DATABASE Trigger:-LOGON/LOGOFF/STARTUP/SHUTDOWN
BY Best Interview Question ON 19 Feb 2019