what is trigger?
What is stored procedures?
What is a cursor?

Answers were Sorted based on User's Feedback



what is trigger? What is stored procedures? What is a cursor?..

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

what is trigger? What is stored procedures? What is a cursor?..

Answer / guest

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

Post New Answer

More Testing AllOther Interview Questions

what is remedy testing,how can use that, plz explain

2 Answers   T systems,


The purpose of which is to allow specific tests to be carried out on a system or network that resembles as closely as possible the environment where the item under test will be used upon release?

0 Answers  


Hi friends, my company has not having any certification related to qulaity say for example iso,cmmlevels,etc... but they want to get cmm-level-5, tell me what are the process to be taken to get cmm-level-5 certification.. pl answer if anyone know the process, thanks in advance.

2 Answers  


What is a 'walkthrough' in Software Testing?

0 Answers   MCN Solutions,


What is software bug?

0 Answers  






What is the negative and positive testing?

0 Answers  


what is the strength of ur company?

8 Answers   MBT, TN,


What do enterprises do for QC 11 to prevent minimum data loss ?

0 Answers   HP,


wat r d schedules for testing?

0 Answers   Mind Q Systems, QA Planet,


I. Customer focus II. Radical process improvement III. Incremental process improvement IV. Quality control specialists are key V. Assumption of unsound processes VI. Human side of quality VII. Measurement and analysis In the statements above, what are the key elements in the TQM philosophy? 1. I, III, VI, and VII 2. I, II, VI, and VII 3. I, II, IV, and VI 4. III, IV, V, and VII 5. I, III, V, and VI

0 Answers  


repeated testing of an already tested program, after modification, to discover any defects introduced or uncovered as a result of the changes in the software being tested or in another related or unrelated software component:

0 Answers  


Explain test driver?

0 Answers  


Categories