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

Answers were Sorted based on User's Feedback



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

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

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

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

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

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

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

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

Post New Answer

More SQL PLSQL Interview Questions

How do I count duplicates in sql?

0 Answers  


What is sql table?

0 Answers  


What is sql and how does it work?

0 Answers  


Does sap use sql?

0 Answers  


What packages(if any) has oracle provided for use by developers?

1 Answers  






in a package one procedure is wrong package shows valid or not

4 Answers  


which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,


write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  


difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,


counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,


Why does %isopen return false for an implicit cursor?

1 Answers  


how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,


Categories