Interested to Buy Any Domain ? << Click Here >> for more details...
what is trigger?
What is stored procedures?
What is a cursor?
- 2 Answers
- 9006 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 |
How is an sql query executed in oracle 8?
What is independent test group (itg)?
What are the types of defects?
What is the average size of executables that you have created?
Explain in a testing project what testing activities would you automate?
suppose u have raised one bug. you have posted to that concerned developer..he can't accept that is a bug. what will u do in the next stage?
What is Software reliability?
What is applications of FCOE?
What is failure?
what is the difference b/w functional testing and system testing?
Explain test driver?
What is the difference between Test strategy and Test plan?
Automation Testing 
