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

Explain the dynamic testing?

0 Answers  


Can anybody post the format of a Requirement Traceability Matrix. And how to include this RTM in the reqirement document.?

1 Answers  


How would you do " Keeping two folders in sync testing"

0 Answers   ABC, HCL, Microsoft,


How many test cases you will execute per day?

2 Answers  


How to write test cases on laptop???

0 Answers   RAS Inforays Technologies,






Credit card field contains four text boxes. We can validate each textbox separately with conditions but how can we write integrated testcase for all the four?

0 Answers  


Write test cases for Wifi enabled devices(Ipad, Iphone, Laptop) Note: Test case should not cover basic functionalty like connect or disconnect. Test case should have out of box thinking & simulation of errors.

3 Answers   Amazon, SCDL Symbiosis Center for Distance Learning,


Could anyone please let me know what are the test cases for a rule based system? WE have a module on RBS which relates the data gathered to a set of rules and uses them to verify if the details are correct. Also we have a data acquisition module which collects the configuration details of a node entering a cluster using the CPUID. Can you please suggest test cases for these two modules, please?

0 Answers  


How you test IP address

6 Answers   CybAge,


How to write test cases for the following scenario: The system shall limit the search result display to 200 records. Do we need to write test data for it. How do we create a test data for it.

0 Answers  


how we test the login page using jwebunit test case...

0 Answers   CTS,


Write a test case scenario for Web-based address book?

0 Answers  


Categories