how to test a store procedure?



how to test a store procedure?..

Answer / Rajiv Ranjan Kumar

To test a stored procedure, you should execute the procedure multiple times with various inputs to ensure it returns the expected results consistently. You should also verify that any output parameters or return values are correctly handled, and check for exceptions or errors.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

I am uma new commer for this site? I have some doubt's pls clarify it..... I finished my B.Com and S/w Testing Course Now iam serarching a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.,

9 Answers  


difference Between Quality assurance and Quality control

7 Answers   EDS,


what are all the possible Test Cases for VoIP based applications

1 Answers  


1. Hai, if we are not having any SRS,BRS docs., how can we prepare the test cases & how can we test the application ? 2. In this, is it possible to make 100% bug free.

4 Answers  


What is the diff between CLient, Customer and End User?

7 Answers   JVS, Societe Generale,


Have anyone got the Cognizant manual testing call letter for interview? Pl reply

2 Answers   Cognizant, HGS,


If you are a test lead. Then how should you know all the requirements are covered in Test Cases if your team member has wrote the test cases?

3 Answers   Virtusa,


Can anyone clarify my doubt that is the defect status cycle and the appropriate person responsible for changing the status.(who is responsible for which status) Ex: New by tester....

3 Answers  


Explain Functionality Testing Techniques

2 Answers   Target,


write negative testcases for notepad

3 Answers   Philips, Wipro,


This question has been asked in my recent inerview with Adithya Birla Group.When to prepare System test plan after getting build or before getting build?

1 Answers   Aditya Birla,


where do you write the test cases

7 Answers   IBM,


Categories