Database Testing Interview Question:

What we normally check for the Database Testing?

Submitted by: Administrator

An1:
In DB testing we need to check for,
1. The field size validation
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures
5. The field size defined in the application is matching with that in the db.

An2:
Database testing involves some indepth knowledge of the given application and requires more defined plan of approach to test the data. Key issues include :
1) data Integrity
2) data validity
3) data manipulation and updates.

Tester must be aware of the database design concepts and implementation rules
Submitted by: Administrator

* Check the Field Name
* Check the Field length
* Index
* Keys(unique,primary and foreign as per your requirement)
* Check and make sure that all data are placed in back end as you insert from front end
* make sure the required calculation is done
* check the SP and Trigger
*calculate the query execution time
Submitted by: Thiraviyam

1.Database Design
2.Database Validation
3.Data Integrity
4.Stored Procedures
5.Performance
Submitted by: Venkat