Database Testing includes verifying stored procedures, table indexes, exceptions, schema's and compatibility.
Different types of Database Testing:
Structural testing
Functional testing
Boundary testing
Stress Testing
Few Sample Scenarios:
- Creating an user account from GUI - How would you ensure the details are stored into table correctly?
- Executing stored procedures in different conditions like valid and invalid conditions.
- Varying data definitions - The data type and length for a particular attribute may vary in tables though the semantic definitions are same. Example: Account number declared as Number ( 9 ) in one table and the same as varchar2( 11 ) in another table.
- Varying data codes and values - The data representation of the same attribute may vary with and across tables. Example: Yes or No may be represented as "Y", "y", "N", "n", "1", "0".
- Misuse of integrity constraints - When referential integrity constrains are misused, foreign key values may left "dangling". Example: Employee record deleted but dependent records not deleted.
- Nulls - Null may be ignored when joining tables or doing searches on the column.
- Inaccessible data - Inaccessible data due to missing or redundant unique identifier value. Example: Uniqueness not enforced.
- Incorrect data values - Data that is misspelled or inaccurately recorded. Example: Indra Nagar - Indra ngr.
- Inappropriate use of views - Data is updated incorrectly through views. Example: Data is properly fetched from the database but first record or last record is not displayed
Different types of Database Testing:
Structural testing
Functional testing
Boundary testing
Stress Testing
Few Sample Scenarios:
- Creating an user account from GUI - How would you ensure the details are stored into table correctly?
- Executing stored procedures in different conditions like valid and invalid conditions.
- Varying data definitions - The data type and length for a particular attribute may vary in tables though the semantic definitions are same. Example: Account number declared as Number ( 9 ) in one table and the same as varchar2( 11 ) in another table.
- Varying data codes and values - The data representation of the same attribute may vary with and across tables. Example: Yes or No may be represented as "Y", "y", "N", "n", "1", "0".
- Misuse of integrity constraints - When referential integrity constrains are misused, foreign key values may left "dangling". Example: Employee record deleted but dependent records not deleted.
- Nulls - Null may be ignored when joining tables or doing searches on the column.
- Inaccessible data - Inaccessible data due to missing or redundant unique identifier value. Example: Uniqueness not enforced.
- Incorrect data values - Data that is misspelled or inaccurately recorded. Example: Indra Nagar - Indra ngr.
- Inappropriate use of views - Data is updated incorrectly through views. Example: Data is properly fetched from the database but first record or last record is not displayed
