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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is metric?

854


What is the step you would follow once you find the defect?

1241


What is test result analyzer?

967


I am going for an interview for back end and ui testing. Can smone tell me some important questions?

1671


repeated testing of an already tested program, after modification, to discover any defects introduced or uncovered as a result of the changes in the software being tested or in another related or unrelated software component:

776


What is virtual address?

791


Can we use agil/scrum methodology in prodcut testing.

1758


Mention what the purpose behind doing end-to-end testing is?

909


Explain the tasks involved in planning and control.

747


When should exploratory testing be performed?

806


List the comparison between FC and FCOE?

2088


How you would allocate a task to team members?

836


WHAT ARE THE VARIOUS RISKS INVOLVE IN TESTING?

2062


When should 'regression testing' be performed?

762


Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie

2188