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?
What is stored procedures?
What is a cursor?

Answers were Sorted based on User's Feedback



what is trigger? What is stored procedures? What is a cursor?..

Answer / anwesha

1>Trigger is a store procedure that executes AUTOMATICALLY
to execute certain actions(insert\update\delete)
2types. . after(before commit opertion and it checked foregn
doesntkey constraint) and instead of(after commit opertion
and it doesnt checked foregn key constraint)

2>Store procedure set of trransactSQL statement.
its return val is mandatory
it may hav parameter(input and output)

3>Function also performs particular task
it alws returns a value.
while creation of table u can use function also as a member

Is This Answer Correct ?    9 Yes 0 No

what is trigger? What is stored procedures? What is a cursor?..

Answer / guest

first of all ,all these are something like functions in'C'
which are used to do some predefined task.
trigger:it is a function which by itself excutes according
to the condition or situation to which we have written.
ex:default emails will be sent to associates of a company
on thier b'day dates.
stored procedure:it is similar to a function which doesn't
return anything.where as function returns something when we
call it.

Is This Answer Correct ?    5 Yes 4 No

Post New Answer

More Testing AllOther Interview Questions

1.WHY DO YOU GO FOR WHITE BOX TESTING,WHEN BLOCK BOX TESTING AVALIABLE? 2.WHY DO YOU MAINTAIN REPOSITERIES AND WHAT IS REPOSITORY?

2 Answers  


What is Use case?

1 Answers   TCS,


What is bottom-up testing?

0 Answers  


What is the term for decomposing a software program so that latent design information can be extracted? 1. Reengineering 2. Regression 3. Restructuring 4. Reusability 5. Reverse engineering

0 Answers  


In "V" model of SDLC which phase correspond to integration testing: 1. Requirements 2. Analysis 3. Design 4. Coding

4 Answers   NIIT,


Who is responsible for document all the issues, problems and open point that were identified during the review meeting

0 Answers  


What is the difference between IIS web server & Apache TOmcat server

4 Answers   ArisGlobal,


hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?

0 Answers  


What is a user friendly software?

0 Answers  


hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq

0 Answers   HCL,


What is the difference between uat (user acceptance testing) and system testing?

0 Answers  


If the client identified some bugs to whom did he reported?

1 Answers   TCS,


Categories