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
How can I get information about foreign keys used in a table?
Explain what should be done when a SQL exception is raised?
How can you retrieve data from the resultset using jdbc?
Is jdbc a protocol?
What is the purpose of the jdbc resultset interface?
How to set NULL values in JDBC PreparedStatement?
How do you insert images into database using jdbc?
Why do we need a jdbcrowset like wrapper around resultset?
What is the use of JDBC DriverManager class?
How to set the attribute concurrency in resultset?
Why would you use setautocommit(false) in jdbc?
How can we disable a constraint ?
What is jdbc stand for?
What are the advantages of using preparedstatement in java?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.