Normally, the things that we check in DB Testing are:
Constraint Check
Validation of a Field size
Stored procedure
Matching application field size to database
Indexes for performance based issues
1- What are the different clauses used in SQL?
2- What are the factors to check during database testing?
3- What is data-driven testing?
4- What are JOINs in SQL, and what types of JOINs are there?
5- What are DCL commands?
6- Does QTP support SQL queries?
7- How is data-load testing performed?
8- What are SQL constraints?
9- What is retesting, and how is it different from data-driven testing?
10- What are indexes and mention different types of indexes?