what is trigger?
What is stored procedures?
What is a cursor?
Answers were Sorted based on User's Feedback
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 |
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 |
1.WHY DO YOU GO FOR WHITE BOX TESTING,WHEN BLOCK BOX TESTING AVALIABLE? 2.WHY DO YOU MAINTAIN REPOSITERIES AND WHAT IS REPOSITORY?
What is Use case?
What is bottom-up testing?
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
In "V" model of SDLC which phase correspond to integration testing: 1. Requirements 2. Analysis 3. Design 4. Coding
Who is responsible for document all the issues, problems and open point that were identified during the review meeting
What is the difference between IIS web server & Apache TOmcat server
hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?
What is a user friendly software?
hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq
What is the difference between uat (user acceptance testing) and system testing?
If the client identified some bugs to whom did he reported?