Write the advantages and disadvantages of trigger


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


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.