Advantages of triggers:
i) It executes randomly.
ii) It cannot consume any memory space.
iii) It executes automatically according to an event.
iv) It can directly link to a database table and perform any changes.
v) It can use DML statement.
vi) It is used with a server computer.
Disadvantages of Trigger:
i) Its results are not stored permanently.
ii) It works only with a client-server architecture.
iii) It uses only insert, delete and update commands from DML.
iv) It specifies a procedural environment.
v) It enforces constant.
vi) It doesn’t apply to Data integrity constant