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

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.

Difference between Verification and validation.

3 Answers   Cap Gemini,

---

What are the various steps you will follow for the defect prevention? What is the procedure?

1 Answers  

---

what r the contents in defect reporting?

3 Answers   MBT,

---

If your current project is US based project, where will your Business Analyst stay ? India or US ??

3 Answers   ADP,

---

In MSBI also we need to write test cases please tell me because iam new to msbi

0 Answers   Accenture,

---

when we need testing

3 Answers  

---

What is heuristics testing?

0 Answers  

---

What is a utility?

0 Answers  

---

What is SDLC and STLC? In analysis phase of SDLC, what exactly the testers will do?

0 Answers   Cap Gemini,

---

Explain branch testing?

0 Answers  

---

What are two formats of WWN defined by the IEEE?

0 Answers  

---

What are test comparators?

0 Answers  

---