Question

types of trigger in dbms
​

Answer 1

Answer:

Trigger is an SQL procedure that initiates an action when an event(insert/delete/update) occurs. They are stored and managed by DBMS. A trigger cannot be called or executed:the DBMS automatically fires the trigger as a result of a data modification to the associated table.

Answer 2

Answer:

DML Trigger: It fires when the DML event is specified (INSERT/UPDATE/DELETE)

DDL Trigger: It fires when the DDL event is specified (CREATE/ALTER)

DATABASE Trigger: It fires when the database event is specified (LOGON/LOGOFF/STARTUP/SHUTDOWN)

Explanation:

hope it helps you!!