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

HI, CAN ANY ONE PLZ EXPLAIN IN SIMPLE WORD WHEN WE DO SANITY TESTING AND SMOKE TESTING AND WHY ? and differance between this two ?

4 Answers  


what is difference between system testing and system integration testing?

3 Answers   HCL, Virtusa,


Explain Peer Review in Software Testing?

0 Answers   MCN Solutions,


What is a user manual?

0 Answers  


Explain unit testing?

0 Answers  


Explain the term bug.

0 Answers  


What are the categories of defects?

0 Answers  


what errors can occur when the page loads?

3 Answers  


What r all the resources u need 4 the project u r currently in?

0 Answers  


what is the test data u prepare fr the multiplication of the 2 integers it s urgent kindly anser fastly

1 Answers   MBT,


suppose u have raised one bug. you have posted to that concerned developer..he can't accept that is a bug. what will u do in the next stage?

1 Answers  


Hi, I am writing ISTQB foudation exam on 9 June 2010. Anyone please send me pdf of the book "Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback)by John A. Estrella " to hsdantot@yahoo.com Thanks Sree

0 Answers  


Categories