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 |
What is the reports view in oracle sql developer?
what are the demerits of sql?
What are the packages in pl sql?
What is a dirty read sql?
What is execute immediate?
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
what are all different types of collation sensitivity? : Sql dba
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
What is hibernate and its relation to sql?
what is collation? : Sql dba
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
What is sql profiler in oracle?
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)