Answer Posted / pratap
There are mainily 3 types of triggers
1> DML Trigger
2> Instead of Trigger written on only view
3> System Trigger
DML Trigger written on table that gets fired on DML events
like
insert or delete or update operation
that trigger may fire
1> After dml event
2> Before dml event these are timings for trigger firing
Instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs
System trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
Database level
Schema level
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
State the different connection methods used for creating different types of sql.
What is a jdbc url?
What driver should I use for scalable Oracle JDBC applications?
What are the different types of JDBC drivers?
What does executequery return in java?
Does jdbctemplate close connection?
What are the different types of lockings in jdbc?
What is getconnection method in java?
What do you mean by odbc?
What are the benefits of PreparedStatement over Statement?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
What are the common tasks of JDBC?
How do I disallow NULL values in a table?
What are the differences between statement and preparedstatement interface?
When does the result for an sql statement return null?