How to test a stored procedure?
Submitted by: AdministratorThere 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Test Cases Job Interview Questions And Answers
Top Test Cases Questions
| ☺ | In a log in page what will be test procedure, test scenario, test description & test steps? |
| ☺ | Do you know mutation testing? |
| ☺ | How would you test a cup and or pencil? |
| ☺ | Explain transaction testing, syntax testing, |
Top Testing Categories
| ☺ | Manual Testing Interview Questions. |
| ☺ | Rational TestSuite Interview Questions. |
| ☺ | QTP Interview Questions. |
| ☺ | Database Testing Interview Questions. |
| ☺ | Software QA Interview Questions. |
