what is trigger?
What is stored procedures?
What is a cursor?
- 2 Answers
- 7816 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 |
When you will deploy Fibre Channel SAN instead of iSCSI SAN?
When should exploratory testing be performed?
What type of review requires formal entry and exit criteria, including metrics?
Other than Mr Nageshwar rao anyone suggest me the other best institute to go for testing.
What is service pack..what is the purpose of this..?This question was asked in an testing interview..that's why i posted this in this category..
1 Answers Infeneon Technologies,
what is the actual time to stop testing a product.
Explain exhaustive testing?
What is the difference between HBA, CNA and NIC?
What is the main objective when reviewing a software deliverable?
What is zoning?
have u write any sanity testcases?
what would be the test plan for agile testing??
Automation Testing 
