ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Testing  >>  Testing AllOther
 
 


 

 
 Automation Testing interview questions  Automation Testing Interview Questions
 Manual Testing interview questions  Manual Testing Interview Questions
 QA Concepts interview questions  QA Concepts Interview Questions
 Mobile Testing interview questions  Mobile Testing Interview Questions
 Test Cases interview questions  Test Cases Interview Questions
 Test Documents Reporting interview questions  Test Documents Reporting Interview Questions
 Testing AllOther interview questions  Testing AllOther Interview Questions
Question
what is trigger?
What is stored procedures?
What is a cursor?
 Question Submitted By :: Uday Kumar. A
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is trigger? What is stored procedures? What is a cursor?
Answer
# 1
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 ?    1 Yes 1 No
Guest
 
  Re: what is trigger? What is stored procedures? What is a cursor?
Answer
# 2
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 ?    1 Yes 0 No
Anwesha
 
 
 

 
 
 
Other Testing AllOther Interview Questions
 
  Question Asked @ Answers
 
I have the experience of about 1yrs and 6 months in software testing. Now i must have to shift from this due to unavailablity of projects. But for now I am not able to find any opening in testing with 1+ yrs experience. Plz anybody mail me if anybody finds any openings. Thank you  2
What is the use of ISTQB certification? How many levels are there in the ISTQB? which certification is helpful for Test Engineers? Intrack1
Hi, Can nybody tel me the kind of testing done on Business Intelligence domain?  1
What r all the cultural barriers u r facing?  1
what is the difference in testing a secured site 'https' & a non-secured site 'http&'  2
How to copy some tables in a DB to another DB in SQL Server CybAge1
Overall what percentage of positive and negetive testcases would you write? Accenture3
What is difference between Access(DBMS) and RDBMS like SQL Server or Oracle?. Why Access is not used in web based application? Disha-Tech4
What is API testing?  2
what is qc&qa Satyam7
What is the difference between Testing and Code review?  1
How you find the performance of a web application by looking at the values of ?Response Time? and ?Pages Per Second??  1
what is the strength of ur company? MBT6
I. Product feasibility II. Software requirements III. Software Design IV. Acceptance test Which of the above reviews are necessary in order to ensure the traceability of requirements in the implemented software? 1. I and II 2. I, II, and III 3. II and III 4. II, III, and IV 5. I, II, and IV  1
What is the minimum criteria for white box?  1
what is SEI? Accenture3
What are the steps to test a Website? Please advise.  2
What certifications can a tester of less than 1 yr experience go for? which is the best certification and how many months of preparation is required?  1
Anybody can suggest me, curretly i am searching for a job on testing but i relieved from old company this JUNE 3O. somebody is asking about this 1 month gap. what is the personal reason i have to tell, Anybody can suggest me in detail.. Thanks in advance...Laxman IBM2
What are your salary requirements?  1
 
For more Testing AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com