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

What is oo integration testing?

0 Answers  


I would like to know the kinds of questions that could come up with regard to backend testing? As i am new to this field would also know if backend testing is restricted only to sql and unix. If at all anyone has any information on the same kindly get back to me..thanks

0 Answers  


What is iso - international organisation for standardizationo?

0 Answers  


When is rtm (requirement traceability matrix) prepared?

0 Answers  


What is Test Script Planner

0 Answers  


Did you write test cases of design phase?

6 Answers  


My team is globally dispersed and I spend most nights on conference calls. Is there any way out to handle my Quality Assurance team?

1 Answers  


What is the difference between preventative and reactive approaches to testing?

0 Answers  


What is Lun masking? Why it is used?

0 Answers  


Raju has two candles with same size ,differ in thickness, one burns 6 hours and other is 4 hours, before going to bed, raju has observed that one candle is double than other. After how many hours he has seen that?

4 Answers   Satyam, VMC,


how many clauses in sql server??? write a query by using clause???

3 Answers  


What is the bottom-up approach?

0 Answers  


Categories