How is stored procedure testing done?

1.	How is stored procedure testing done?
Answer» Stored Procedures are similar to user-defined functions that are invoked using Cal PROCEDURE or Execute Procedure statements. The output of these procedures is GENERALLY in the form of result sets. The stored procedures are stored in RDBMS and are READILY available for the applications. These can be tested using the following techniques: White box TESTING: Here, the stubs are used for invoking stored procedures and the results of those are validated against our expected results. Black box testing: We perform operations on the front-end view of our application in a way that the stored procedures are invoked and we validate the result by observing the changes in the view.

Answer»

Stored Procedures are similar to user-defined functions that are invoked using Cal PROCEDURE or Execute Procedure statements. The output of these procedures is GENERALLY in the form of result sets. The stored procedures are stored in RDBMS and are READILY available for the applications. These can be tested using the following techniques:

White box TESTING: Here, the stubs are used for invoking stored procedures and the results of those are validated against our expected results.
Black box testing: We perform operations on the front-end view of our application in a way that the stored procedures are invoked and we validate the result by observing the changes in the view.

Discussion

No Comment Found

Related InterviewSolutions

What are the different SQL statements that can be used for database testing?
How will you know if a trigger is fired or not at the time of database testing?
How is stored procedure testing done?
How do you validate whether the database table has been updated after you enter data from the front-end application?
Explain with an example how you can test the database manually?
What do you understand by retesting and how is it different from data-driven testing?
What do you understand by validation of ACID properties in database testing?
What would be the SQL statements used for managing and manipulating the test tables?
What do you understand by Non-functional testing in terms of database testing?
What do you understand by Keys and indexes Testing?

How is stored procedure testing done?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment