What is a database trigger ? Name some usages of database
trigger ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tina
Database triggers are invoked on database level (not on
table level). For e.g. you can write the triggers as and
when database is shutdown or database is getting on etc...
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sohail
Database trigger is a 4th named block in oracle.The usage
of database trigger is to audit data modification.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / amol maske
Database triggeris the stored procedure called when the
insert, update, delete (DML statement) fired
| Is This Answer Correct ? | 1 Yes | 0 No |
Is and as keyword in pl sql?
Difference between truncate, delete and drop commands?
How many columns should be in an index?
how to create a table index in mysql? : Sql dba
What is varray in pl sql?
What are types of exception?
How do you copy a table in sql?
what is a view? : Sql dba
What is union and union all keyword in sql and what are their differences?
Compare SQL and PL/SQL.
How do you optimize a stored procedure query?
What are the difference between Functions/Stored Procs and Triggers and where are they used.
Oracle (3253)
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)