30 database testing interview questions and answers

Ask a question
          

Database testing interview questions and answers


<<Previous  Next>>
Part 1  Part 2  Part 3  Part 4  Part 5  Part 6 
1.What is Database testing?

Latest answer: 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...............
Read answer

2.What are ways of writing test cases for database testing?

Latest answer:

  • The backend tables used for each requirement must be mentioned.
  • Behavior of each flag and their status updates must be written................
    Read answer

3.What are the different stages involved in Database Testing?

Latest answer:

  • The data that is being inserted in the database must be verified.
  • Verify if the constraints are maintained.................
    Read answer
4.Explain how to test data loading in database testing.

Latest answer: 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..............
Read answer

5.Explain how to test a SQL Query in Winrunner.

Latest answer: Using Output database checkpoints, SQL manual queries options must be selected. Here, the select query can be written.................
Read answer

6.Explain how to test database Procedures and Triggers.

Latest answer: 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...................
Read answer

7.What steps does a tester take in testing Stored Procedures?

Latest answer: 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....................
Read answer

More Related Links

Define pareto principle or 80/20 principle.

Answer - It is one way of tackling problem in management. It says 20% of the......

Describe each levels of CMMI

Answer - At this level, there is no proven processes and has no stable environment in the organization. This type of organization......

What is Black box testing? What is White box testing? 

Answer - White box testing is done to test the accuracy of logic and code of the program. It is done by programmers......

What is Six Sigma? Who forms the part of Six Sigma implementation team? 

Answer -  It is a methodology and set of tools for the measurement of process quality. It demonstrates that the business .....

What are the differences between system and functional testing?

Functional testing involves testing of functional requirements as per the specification..........

How does WinRunner evaluate test results?

Once the test is executed, a report of the results is displayed by WinRunner. The report shows....

How do you configure GUI map in WinRunner?

WinRunner when learning the description of a GUI object learns only the required properties to identify the object..............

What is load testing? What is Performance testing?

Load testing is pressurizing the system until its threshold to see its response. Example can be allowing...........

<<Previous  Next>>

 

 
 
Home | Login | About us | Sitemap | Contact us