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 is trigger?

Answers were Sorted based on User's Feedback



what is trigger?..

Answer / shanthi bhushan

Trigger is procedure which is automatically fires when we
modify the data in table(After i.e.,Data Manipulation wiil
be one)

Is This Answer Correct ?    14 Yes 0 No

what is trigger?..

Answer / naresh

Trigger is just like a storedprocedure but the only
difference is it is automatically call when the event ocour
or fire.

Is This Answer Correct ?    11 Yes 2 No

what is trigger?..

Answer / srividhya.s

Triggers are simply stored procedures that are executed
automatically by the database whenever
some event (usually a table update) happens.

sample:

CREATE [OR REPLACE]
TRIGGER trigger_name
BEFORE (or AFTER)
INSERT OR UPDATE [OF COLUMNS] OR DELETE
ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
DBMS_OUTPUT.PUT_LINE(’Ur message to be
displayed ’ :NEW.NAME);
END;

Is This Answer Correct ?    9 Yes 1 No

what is trigger?..

Answer / roopesh kumar

A trigger is a DB object like proc. or func. stored in data
dictonary. It will fire implicitly with event on which it
written.

Main use of a trigger are

-- we can take backup of data.
-- Can be used for auditing purpose.
-- For applying complex bussiness rule.
Etc.

Is This Answer Correct ?    3 Yes 0 No

what is trigger?..

Answer / srini

Trigger is a special kind of stored procedure executed
certain event occurs.

Is This Answer Correct ?    3 Yes 0 No

what is trigger?..

Answer / sudha

trigger is stored procedure it execute the one event
when another event is happenning for example it can do the
insert operation as well as select operation.

Is This Answer Correct ?    2 Yes 0 No

what is trigger?..

Answer / monika mudgal

Trigger are events that perform some action.

Is This Answer Correct ?    2 Yes 0 No

what is trigger?..

Answer / aarthi

trigger is used nto change the control from one state to
another

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

0 Answers  


what is ado.net

6 Answers   Karrox, SunGard,


Where does ADO.NET and XML web services come in the architecture ?

1 Answers   IBM, TCS,


What are the different ado.net namespaces?

0 Answers  


How can we load multiple tables in a dataset?

0 Answers  


What is difference between datagridview and datagrid control in winforms?

0 Answers  


What are disadvantages of microsoft-provided data provider classes in ado.net?

0 Answers  


How do you handle data concurrency in .NET ?

9 Answers   Infogain, SunGard,


Which is faster ado.net or linq?

0 Answers  


What is ole access?

0 Answers  


How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

0 Answers   SwanSoft Technologies,


What are the features of ado.net?

0 Answers  


Categories