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

Write a test case of login window?

0 Answers  


What is the role of QA in a development project?

6 Answers  


How to write a Scenario and test cases for escalator

7 Answers   ABC, Accenture, CTS,


test case for digital camera

2 Answers  


write a test case for telephone billing ?

0 Answers   CTS, Infosys, TATA,






Analyze the following highly simplified procedure: Ask: "What type of ticket do you require, single or return?" IF the customer wants ‘return’ Ask: "What rate, Standard or Cheap-day?" IF the customer replies ‘Cheap-day’ Say: "That will be £11:20" ELSE Say: "That will be £19:50" ENDIF ELSE Say: "That will be £9:75" ENDIF Now decide the minimum number of tests that are needed to ensure that all the questions have been asked, all combinations have occurred and all replies given. A. 3 B. 4 C. 5 D. 6

1 Answers   ISTQB,


why we need a test plan

11 Answers  


For how many days (or) weeks you will test a product or software?

0 Answers  


how to write a test cases for Quick links like Feedback/Suggestions Advertise with us Contribute Invite a Friend FAQs Make HomePage RSS Feed Buzz Words Email Privacy Statement Terms & Conditions Copyright Disclaimer Download Forgot Password

0 Answers   Cap Gemini,


testcases for biggest of three numbers?plz give the answer

5 Answers   IBM,


write a test case for yahoo login page ? input data user:6 alpha numeric;password:10 letters....10 pstive test cases and 10 negative test cases?

5 Answers   CTS, iGate, Magic Software,


test cases on Fan

13 Answers   TCS,


Categories