how to testba storedprocedure?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the format of a requirement traceability

637


Give me a example that differentiate Test case Procedure,Test case Scenario,Test case Discription & test steps.

2206


If userA send a string through whatsapp but userB is not getting properly the string, Then what may be problem? Can someone write testcase of this. Both whtsapp application is same version and OS is also same android version.

1565


Explain the system testing?

693


can any body help me with providing a a case for usability testing...

1680






I need GUI test case for home page?

3220


write a test case for telephone billing ?

3904


What is the toughest moment you faced in your testing carrier in which everyone praised you?

1820


Explain the glass box testing?

667


Hi Team, I have two scenarios ,only one step alone deference betweeen them and preconditions of Test scenarios are defferent . In the above sutuation , are we going divide test cases into two or can we club into them into a single. Regards seshu

1783


Explain the static testing?

705


write the testcases for migrating data from one database to another database?

1904


Do you know mutation testing?

704


write test case for pen cap if it is not present?

2103


What is test cases for mobile phone ?

786