Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Explain interface?

0 Answers  


Mention what are the categories of defects?

0 Answers  


What is the bottom-up approach?

0 Answers  


what r the strategies & methodologies r u following in preperation of test cases based on usecase?

0 Answers   MBT,


may i know the sites which r giving model question papers for istqb exam

2 Answers  


What is utilization?

0 Answers  


what do i expect in a second interview for a system tester position

0 Answers  


Write a function Occurrences() in a language of your choice that takes in two strings. The first is a search string, and the second is a sentence. For example, running the function: Running Occurrences ("o", "Red Gate Software - Ingeniously Simple Tools") will output: Occurrences of 'o': 4 Occurrences ("at", "The cat sat on the mat") will output: Occurrences of 'at': 3 Sample Question 2: 2)Below is Notepad's File/Save dialog. a) If you were asked to test this dialog, how would you go about it? b) List various inputs you might place into the "File name" text field to test it.

0 Answers  


Explain dynamic testing?

0 Answers  


What is non-intrusive testing?

0 Answers  


What is latent defect?

0 Answers  


Which is the best institute in chennai to learn Softyware testing? Please help.

0 Answers  


Categories