What are the different types of database testing

Question

I have heard that there are 3 types of database testing. Could you please brief me up about the same?

Answer 1

The 3 types of Database Testing are

1. Structural Testing
2. Functional Testing
3. Non-functional Testing

Structural database testing

The structural data testing involves the validation of all those elements inside the data repository that are used primarily for the storage of data and which are not allowed to be directly manipulated by the end users. The validation of the database servers is also a very important consideration in these types of testing. The successful completion of this phase by the testers involves mastery in SQL queries.

Schema testing

The chief aspect of schema testing is to ensure that the schema mapping between the front end and back end are similar. Thus, we may also refer to schema testing as mapping testing.

Database table, column testing

Let us look into various checks for database and column testing.

1. Whether the mapping of the database fields and columns in the back end is compatible with those mappings in the front end.
2. Validation of the length and naming convention of the database fields and columns as specified by the requirements.
3. Validation of the presence of any unused/unmapped database tables/columns.