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
What is metric?
What is the step you would follow once you find the defect?
What is test result analyzer?
I am going for an interview for back end and ui testing. Can smone tell me some important questions?
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:
What is virtual address?
Can we use agil/scrum methodology in prodcut testing.
Mention what the purpose behind doing end-to-end testing is?
Explain the tasks involved in planning and control.
When should exploratory testing be performed?
List the comparison between FC and FCOE?
How you would allocate a task to team members?
WHAT ARE THE VARIOUS RISKS INVOLVE IN TESTING?
When should 'regression testing' be performed?
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie