Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the various types of database triggers ?

April 26, 2017database triggers types various

0

Posted

What are the various types of database triggers ?

2 Answers

0

Posted

There are 12 types of triggers, they are combination of : Insert, Delete and Update Triggers. Before and After Triggers. Row and Statement Triggers. (3*2*2=12) 16.What is the advantage of a stored procedure over a database trigger ? We have control over the firing of a stored procedure but we have no control over the firing of a trigger. 17.What is the maximum no.

0

Posted

Ans – There are 12 types of triggers : • Insert, Delete and Update Triggers. • Before and After Triggers. • Row and Statement Triggers.