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 |
What is failure?
What is the most difficult problem you’ve found during testing?
Explain what n+1 testing is?
To test a function, what has to write a programmer, which calls the function to be tested and pass test data.
I got an offer from TCS as a software engineer, But it says I will work for TCS BPO, Is there any difference in policies of TCS BPO and TCS-IT Services.How is the Working enviornment and appriasal procedure
Which one of the following is used as a tool for tracking an SQA project? 1. Pareto chart 2. PERT chart 3. Run chart 4. Control chart 5. Cause and effect chart
Hi I would like to ask a general question, I finished my post graduation(arts)a long back say 2000. I have a diploma in IT. And I have completed a course in testing(2010). What are my chances of getting a job in testing. I really have an apitude for testing and if given an opputunity I will do well. But I have been sent away after apitude tests which I know I did well(3 or 4 might have gone wrong), hr rounds. Can u tell me if I will get a job at all. Really I feel very let down. Give suggestions that will work thanx
When is a test considered to be successful?
How to copy some tables in a DB to another DB in SQL Server
How to test online application.
What is bottom-up strategy?
hai, what is v-model