what is trigger?
What is stored procedures?
What is a cursor?
- 2 Answers
- 7989 Views
- SumTotal, I also Faced
- E-Mail Answers
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 |
What is execution?
you are a SQA lead on a project that uses an agile development environment, The lead developer has been instructed to write and initially-failing automated test case, then produce minimum amount of code to pass the test and finally refactor the new code to acceptable standards. based on above, Which type of SQA-focused SDLA is being used?
Explain interface?
When is a test considered to be successful?
What are two formats of WWN defined by the IEEE?
Mention what the main advantages of statement coverage metric of software testing are?
what are the main bugs which were identified by you and in that how many are considered as real bugs?
Which was the first game introduced Bullet Time Future a) Matrix path of Neo b) Serious Sam c) Max Payne d) War craft
What is problem?
What is test management review and why it is important?
Define defect density.
What is depth testing?
Automation Testing 
