What is trigger ?

Answer Posted / piyush

Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is sql used in sql server?

505


What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

548


How to get the definition of a user defined function back?

571


What is a file group?

627


How can we migrate from SQL server to SQL Azure?

92






query processing

1740


What are different types of statement?

527


how many bits ip address consist of? : Sql server database administration

466


What is deploy, process and build? : sql server analysis services, ssas

575


What is the impact on other user sessions when creating indexes?

544


What are drillthrough reports?

102


What is SQL Azure?

85


Explain what is “asynchronous” communication in sql server service broker?

496


What are the different types of locks in the database?

488


Tell me extended events in sql server 2008?

565