InterviewSolution
| 1. |
How To Test The Stored Procedure? |
|
Answer» You first unit-test each procedure by feeding it appropriate test data, observing the outcome, and RETESTING as needed to make sure the BUG fixes contain no new errors. Unit-testing a stored procedure involves a series of test-debug-retest CYCLES. The NUMBER of cycles will depend on your company's defect tolerance, your application's release date, and, of COURSE, the "bugginess" of your code. You first unit-test each procedure by feeding it appropriate test data, observing the outcome, and retesting as needed to make sure the bug fixes contain no new errors. Unit-testing a stored procedure involves a series of test-debug-retest cycles. The number of cycles will depend on your company's defect tolerance, your application's release date, and, of course, the "bugginess" of your code. |
|