|
Interview Question : How to test a stored procedure?
Answer : 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.
Interview Question Category : Manual Testing
|
