Sreejobs Logo
   For Latest Job Updates  
sreenutech.com Online Exams
Home Govt Jobs IT Fresher Jobs IT Exp Jobs IT Walk-Ins MBA Jobs BPO Jobs Register FAQ’s Post Job Contact Us
Hot Jobs
DateaBase Testing FAQs

What is Database testing?
Database testing involves testing the behavior of the database when the application is being tested. This may involve testing to see if values are being inserted properly, flags are changing

What are ways of writing test cases for database testing?
The backend tables used for each requirement must be mentioned. Behavior of each flag and their status updates must be written.

What are the different stages involved in Database Testing?
The data that is being inserted in the database must be verified.
Verify if the constraints are maintained.

Explain how to test data loading in database testing.
The data from source tables to target tables in terms of data types and constraints must be verified. The number of rows of source and target tables must be compared.

Explain how to test a SQL Query in Winrunner.
Using Output database checkpoints, SQL manual queries options must be selected. Here, the select query can be written.

Explain how to test database Procedures and Triggers.
The input parameters and output parameters must be known. EXEC statement can be used to run the procedure to examine the behavior of the database.

What steps does a tester take in testing Stored Procedures?
The tester should call the stored procedure in the backend using the EXEC command. Here, if any parameters are required, they must be passed. Different values of parameters must be passed to confirm if the stored procedure is executed or not.

Home | Register for Job Updates | Contact Us