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 are different types of keys in sql?
Which data type is a composite type?
what is auto increment? : Sql dba
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
how to get help information from the server? : Sql dba
What is the difference between the sql*loader and import utilities? : aql loader
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is compound trigger?
what are the advantages of primary key over unique+notnull
7 Answers Consultancy, LGS, Oracle,
what is a stored procedure? : Sql dba
What is the use of 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)