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 friends, I am planning to take up foundation level ISTQB Certification exam in March. Anybody having the study materials and sample papers please mail sunkumaranr@gmail.com Thanks in Advance...

0 Answers  


What is Test Data Collection?

2 Answers   SumTotal,


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  


Given alone a functional specification docs if a test plan is to be prepared without any prototype and the product or the appli is to be delivered within 10 days ..How to prepare test plan and prepare test cases ? Cheers, Amar.gp

2 Answers   Wipro,


I need to learn everything I can about the different types of Test Activities (i.e., Test Strategy, Test Plan, Test Cases, etc.). What is the best online resource?

0 Answers  






Can any of u help me... How to use Security below listed testing tools 1. XSS Probe 2. SQL Power Injector 3. CAL9000 I have to do security testing using these tools.But I do not have any knowlwdge on this. I am trying to work using Help doc, but use, not able to follow Pls do needful

0 Answers  


What is glossary of software qa/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  


What is zoning?

1 Answers  


please suggest me some topics for research in software testing/software reliability......

0 Answers  


what is qc&qa

8 Answers   Satyam,


What do you think is the perfect test management system for test service vendors like me?

1 Answers  


Categories