Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Diff. types of triggers..

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


Please Help Members By Posting Answers For Below Questions

How can I get information about foreign keys used in a table?

951


Explain what should be done when a SQL exception is raised?

961


How can you retrieve data from the resultset using jdbc?

1042


Is jdbc a protocol?

913


What is the purpose of the jdbc resultset interface?

897


How to set NULL values in JDBC PreparedStatement?

966


How do you insert images into database using jdbc?

1057


Why do we need a jdbcrowset like wrapper around resultset?

1227


What is the use of JDBC DriverManager class?

1045


How to set the attribute concurrency in resultset?

913


Why would you use setautocommit(false) in jdbc?

1178


How can we disable a constraint ?

1003


What is jdbc stand for?

905


What are the advantages of using preparedstatement in java?

969


Give a way to check that all result sets have bin accessed and update counts are generated by execute method.

930