How to Test Database Procedures and Triggers?

Database Testing Interview Questions

(Continued from previous question...)

6. How to Test Database Procedures and Triggers?

Before testing Data Base Procedures and Triggers, Tester should know that what is the Input and out put of the procedures/Triggers, Then execute Procedures and Triggers, if you get answer that Test Case will be pass other wise fail.
These requirements should get from DEVELOPER

(Continued on next question...)

Other Interview Questions

• What we normally check for in the Database Testing?
• What is Database testing?
• How to Test database in Manually? Explain with an example
• What is data driven test?
• How to check a trigger is fired or not, while doing database testing?
• How to Test Database Procedures and Triggers?
• Is a "A fast database retrieval rate" a testable requirement?
• How to test a DTS package created for data insert update and delete? What should be considered in the above case while testing it?What conditions are to be checked if the data is inserted, updated or deleted using a text files?
• How to test a SQL Query in Winrunner? without using DataBase CheckPoints?
• How do you test whether a database in updated when information is entered in the front end?
• How do you test whether the database is updated as and when an information are added in the front end?Give me an example?
• What steps does a tester take in testing Stored Procedures?
• What are the different stages involved in Database Testing
• How to use SQL queries in WinRunner/QTP
• What is database testing and what we test in database testing?
• What SQL statements have you used in Database Testing?
• How to test data loading in Data base testing?
• What is way of writing testcases for database testing?
• ;What is Database testing?
• What we normally check for in the Database Testing?