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.
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?
How to test database procedures and triggers?
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?
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 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?