What is a database trigger ? Name some usages of database
trigger ?

Answer Posted / swapnareddy

Database trigger is a stored procedure that invokes
automatically when a predefined event occurs.
The usage of database trigger is to audit the data modification.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How subquery works in sql?

727


How exception handling is done in advance pl/sql?

671


Can a trigger call a stored procedure?

747


How do you drop a trigger?

711


How do I edit a stored procedure?

722






Why truncate is used in sql?

720


Explain the components of sql?

789


what are the security recommendations while using mysql? : Sql dba

768


Are pl sql variables case sensitive?

769


What are all different types of collation sensitivity?

737


What is crud diagram?

677


Why we use joins in sql?

723


Which is better trigger or stored procedure?

688


what is table? : Sql dba

763


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1325