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 are the security recommendations while using mysql? : Sql dba

0 Answers  


What is a composite primary key?

0 Answers  


Explain Connect by Prior?

2 Answers  


What is varchar data type in sql?

0 Answers  


Which is better stored procedure or query?

0 Answers  


what is try_catch block in procedure

0 Answers  


What sql database should I use?

0 Answers  


how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,


What is right join sql?

0 Answers  


What does trigger mean in slang?

0 Answers  


What is meant by <> in sql?

0 Answers  


There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,


Categories