Database Testing Interview Questions and Answers

Database Testing Interview Questions and Answers

Database is the important role in software applications system. DB testing is the process of validating that the structure and data stored in the database meets the requirement and design. It is mainly used to data quality and web application performance issues that might otherwise get detected only after the application has been live for some time. There are database has four layers are user interface (UI) layer, business layer, data access layer and the database itself. These layers are more important for a database testing system.

What is database testing?

In database testing, what do we need to check normally?

Explain what is data driven test?

What are joins and mention different types of joins?

What are indexes and mention different types of indexes?

While testing stored procedures what are the steps does a tester takes?

How would you know for database testing, whether trigger is fired or not?

In data base testing, what are the steps to test data loading?

Without using Database Checkpoints, how you test a SQL Query in QTP?

Explain how to use SQL queries in QTP?

What is the way of writing test cases for database testing?

To manage and manipulate the test table what are the SQL statements that you have used in Database testing?

How to test database procedures and triggers?

How you can write test cases from requirements and do the requirements represents exact functionality of AUT (Application Under Test)?

What is DBMS?

What is DML?

What are DCL commands? What are the two types of commands used by DCL?

What is white box testing and black box testing?

How does QTP evaluate test results?

Explain the QTP testing process?

What is load testing and give some examples of it?

How to test database manually?

What RDBMS stands for and what are the important RDMBS that SQL use?

What is performance testing and what are the bottlenecks of performance testing?

What is DDL and what are their commands?

What do you mean by data-driven test?

What is the database trigger, how to verify the trigger is fired or not and can you invoke trigger on demand?

After entering the data from the front-end application interface, how do you test whether a database in updated or not?

How to test the Stored Procedures?

What are joins and mention different types of joins?

What do you mean by index and explain different types of indexes?

What do you mean by DBMS?

What do you mean by DML?

What do you mean by DCL commands and explain the types of commands used by DCL?

What do you mean by white box testing and black box testing?

Does QTP support SQL queries, how to use SQL queries in QTP?