How a trigger can help in improving performance? How many types of triggers are there and What do they do?

Showing Answers 1 - 6 of 6 Answers

I can answer for types of triggers
Types to triggers :

?1. Database trigger: can be?executed before and after the dml commands
?????? a. Row level: if we want to cahnge any row then row level triggers are fired
???????b. Statement level: it is executed eventhough no row is changed from the table.
?2. Form? trigger

  Was this answer useful?  Yes

chandraagi

  • Oct 3rd, 2008
 

Use of triggers: we can do the record insertion/deletion/updation when we perform certain operation on a table or database logon and logoff
Improves the security of data and tracking the changes done on a table records
based on the type operation triggers are Insert, Update, Delete

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions