how to testba storedprocedure?



how to testba storedprocedure?..

Answer / yash

There are two ways to test a stored procedure.

1)Black box testing: The Result Set should be checked if the
desired output is returned by SQL command.

2)Performance Testing: Stored Procedures are created to
avoid compiling it again and again. hence, testing should be
done to check if stored procedures are reducing CPU load and
network traffic.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Test Cases Interview Questions

(questions asked in interview)hi every one can any one please answer to this questions.these questions were asked in an interview.i have another interview next week . 1.when the time schedule is tight how will you approch the testing,and the relese is nearing and we need to finish testing how can we follow in that case.do we need to exicute all the test cases or can priortise and leave some to next relase. 2. when a new feature is added to the existing application we need to add new test cases but after that do we need to change all the existing test cases and while running do we need to exicute entire application test cases or only the new feature test cases and related new feature test cases. 3.do you have any situation where you have to write and exicute the test cases same time, how will you follow.does it happens in real time. 4.example of bug which is not reproducible.like tester say that there is bug and developer say no can some example of such bugs. 5.during regression testing some times do we need to add new some additional test cases to test that bug.

3 Answers  


can u say me how many test cases i can get for a user to login and enter password ..please specify in testcase desing template for that

7 Answers   Wipro,


How to write test cases on laptop???

0 Answers   RAS Inforays Technologies,


to write test cases for fuel guage?

1 Answers  


how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me. some real time database tester please answer my question as soon as possible.my need is such that. else mail answer at ina.ref@gmail.com

1 Answers  






How to write test scenarios for a Web application, with an example?

3 Answers   Deloitte, LiveTech, TCS,


Explain the scalability testing?

0 Answers  


You have to give me test cases for sending a mail through outlook express.

3 Answers   Mind Tree,


Write a test case of login window?

0 Answers  


Who will take care of test plan and test case?

0 Answers  


Do you know mutation testing?

0 Answers  


How to write test cases for manual testing? What are the main syntex for writing test cases for Junit?

0 Answers   Wipro,


Categories