How do you test the database triggers and procedures?

1.	How do you test the database triggers and procedures?
Answer» For testing the database triggers and procedures, it is required to KNOW the input parameters to these functionalities and know what would be the expected output for these. The EXEC statement can be used for determining the behaviour of the TABLES when the procedures or triggers are run. You can also achieve this by creating SQL unit tests for checking the database objects modified due to the EXECUTION of the triggers or procedures. The SQL unit tests follow the 3 rules as shown below: The test case should check whether the objects exist in the database or not. It should check or validate what the normal outputs would be for success scenarios. It should also check for the behaviour of the system under the influence of NEGATIVE test cases.

Answer»

For testing the database triggers and procedures, it is required to KNOW the input parameters to these functionalities and know what would be the expected output for these. The EXEC statement can be used for determining the behaviour of the TABLES when the procedures or triggers are run.

You can also achieve this by creating SQL unit tests for checking the database objects modified due to the EXECUTION of the triggers or procedures. The SQL unit tests follow the 3 rules as shown below:

The test case should check whether the objects exist in the database or not. It should check or validate what the normal outputs would be for success scenarios. It should also check for the behaviour of the system under the influence of NEGATIVE test cases.

Discussion

No Comment Found

Related InterviewSolutions

What are the differences between GUI Testing and Database Testing?
How will you fetch the values from TableA that are not present in TableB without using the NOT keyword?
Is it possible to have multiple primary keys in a table?
How do you check for an error in a stored procedure consisting of 1000s of lines of code?
How can you validate the tables and columns in the database?
What are the best practices that need to be followed while performing database testing?
What are the most commonly occurring issues that are faced during database testing and how can they be solved?
How can you test the data integrity in database testing?
How can you validate the ACID properties? Explain with an example.
How can you test Transactions in SQL Databases?