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...


What are the types of triggers ?

Answers were Sorted based on User's Feedback



What are the types of triggers ?..

Answer / manikandan

1)database trigger
2)application trigger

Is This Answer Correct ?    0 Yes 2 No

What are the types of triggers ?..

Answer / sam katwal

There are three types of Triggers
Insert Trigger
Update Trigger
Delete Trigger
One Trigger also exists
Instead of Trigger which was introducted in SQL Server 2000

Is This Answer Correct ?    21 Yes 24 No

What are the types of triggers ?..

Answer / ramprakash

Instead of Triggers
After Triggers

Is This Answer Correct ?    15 Yes 18 No

What are the types of triggers ?..

Answer / sandeep chawdekar

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 4 No

What are the types of triggers ?..

Answer / anandkumar

DDL and DML Triggers

Is This Answer Correct ?    13 Yes 20 No

What are the types of triggers ?..

Answer / arjun singh

INSERT TRIGGER
UPDATE TRIGGER
DELETE TRIGGER

Is This Answer Correct ?    7 Yes 22 No

Post New Answer

More SQL PLSQL Interview Questions

what is rdbms? : Sql dba

0 Answers  


Does pl/sql support create command?

0 Answers  


What are the different dcl commands in sql?

0 Answers  


Can a select statement fire a trigger?

0 Answers  


How do you get column names only for a table (sql server)?

0 Answers  


What is sqlerrd?

0 Answers  


Can you selectively load only those records that you need? : aql loader

0 Answers  


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  


how can create data base link for tow servers (scott schema) give examples plz

2 Answers  


How does postgresql compare to "nosql"?

0 Answers  


Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  


What is linq to sql?

0 Answers  


Categories