Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 integration testing?

1175


Sample test cases for data conversion(Utility billing system)

7527


Can someone tell me the test cases to test the password for with following scenario: 1. Password should be minimum 6 chars and maximum 8 chars. 2. Password should consist one uppercase letter 3. Password should consist of one numeric 4. Password should consist of one special character.

2141


Why does the boundary value analysis provide good test cases?

1188


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

2561


please give me different test scenario for uploading whatsapp status from gallery and camera

6054


Write test cases to test a browser app

1805


You have designed test cases to provide 100% statement and 100% decision coverage for the following fragment of code. If width > length then biggest_dimension = width else biggest_dimension = length end_if the following has been added to the bottom of the code fragment above. Print 'biggest dimension is ' &biggest_dimensionprint 'width: ' & width print 'length: ' & length how many more test cases are required?

1449


What are all the companies are doing manual testing till now ?

2051


write test case for button of google page?"i am feeling lucky" if button is not appear on page?

3006


write test cases for hospitality management system

2638


If I wrote test cases for Login Window with test case Name Login window & test case id L_01.Now if Name of Login window get changed in the next version.then May I have to change the Test case name & Test case id OR HAVE TO block the previous test case and write the new one

2483


what is the test plan for ms-word

2511


Can anybody help me in writing test cases for a scenario? need help at the earliest. will send you the requirement doc to your email id. thanks raj

2322


IN MY APPLICATION SOME WINDOW IS THERE IT CONSISTS OF SOME 25 LABLES IN THOSE FOR THE ALREADY SELECTED ONE IT WILL SHOW THE BACKGROUND COLOR IS YELLOW WHILE CHECKING IT SHOULD CHECK THE ALL LABLES WHICH ONE IS HAVING YELLOW COLOUR backcolor=SwfWindow("ALTAIR").SwfWindow("Load Wafer").SwfLabel(" ").GetROProperty("backcolor") SUPPOSE LIKE DS IT WILL BE THERE THEN FOR THAT SwfLabel(" ") inside this how to specify is my doubt because i have to check all the 25 labels plz explain it how to specify that

2420