In Database Testing we validate if the proper data is maintained at Backend. We also validate the Stored Procedure return the expected result.
Database testing can be categories at the following.
1. Data validity testing
2. Accessibility testing
3. data integrity testing
4. database performance testing
5. Security testing
6. Database stored procedure testing and other database objects like functions,triggers etc.
Data validity testing
Test data is in proper format or not. For example , a database table is designed with one numeric ,one text and one date field, While inserting data , to the table data and column type should match .
Accessibility testing
Test database object accessibility for database.Before going to fire any database statements on an database object, make sure that the object is accessible or not.
Integrity testing
Testing relationship of the database objects as per the business rule.Referential integrity and all other database constraints to be tested.Test that all DML statements(Insert/updtae/delete) executed properly and transactions are successfully executed. Test the changes performed by DML statement meets business functional requirements.
Stored Procedure Test
Functionality of each stored procedure is to be tested separately as per the purpose of the procedure.All action units of the procedure to be tested separately and observed the modularity and data flow as per requirement.Before going to test stored procedures, a test case should be prepared considering the following parameters.
* No of arguments to be passed and their types (IN,OUT,INOUT)
* The data type of each of the arguments
* The order of the arguments
* Return value -if any
* Datatype of the return value
* Functionality of the procedure
Data type Test
It is very essential to test that input value to the stored procedure is to be in proper format.Before passing the value it is essential to validate the value with data type of the column of the table.
Data size testing
Make sure that the size of the data not exceeded the size of the column of the table . Performance of data size testing is often done only at the front end during the unit testing, but it is essential to perform it at back end separately. This ensures smooth transition while appending functionality and integrating modules as during these phases, the data is passed to the system with direct user interaction and bypassing front end validation.
Event action testing
If a trigger is a part of the procedure , then make sure that the trigger fires on the defined event .If required ,this can be tested on back-end with help of DBAs . To know about DBA related topics please visit http://www.dbazone.in/ .Test the action performed by the above stated events. Here the content of such stored procedures or scheduled actions are verified for the functionality.
Database Security testing
Testing atabase security audits, penetration tests, and vulnerability
