What is trigger ?
Answers were Sorted based on User's Feedback
Answer / ramesh tankala
Trigeer is like stored procedure which executes
automatically .
Trigger is User defined data integrity
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / 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 |
Answer / indu bala
trigger is any event which is raised automatically by
database server after any instruction like
update,delete,insert is performed
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / kalyana chakravarthy maddipati
A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramya
Trigger is a server-side progrm used for events(user
actions-click,key press etc..)
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / abdulla
Trigger is Limited form stored procedure associated with tables.
| Is This Answer Correct ? | 0 Yes | 2 No |
How to Install SQL SERVER 2005 remotely?
Can we create clustered index on composite key?
What are extended events in sql server?
What is the use of SCOPE_IDENTITY() function?
What is #temp and @table variable in SQL server?
Explain features of analysis services?
Where is localdb stored?
Does an index slow down updates on indexed columns?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Mention the different types of triggers?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is the difference between a clustered index and a non-clustered index?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)