Home Java Overview Maven Tutorials

Sunday, 18 June 2017

Manual Test Cases for Database testing

Manual Test Cases for DATABASE TESTING.

Hello friends in this session , we i will write some basic test that must be performed on a database.
As a tester you need to validate below test:-

0. Verify that only authorize user can access the database.
1. Check if correct data is getting saved in database upon successful page submit

2. Check values for columns which are not accepting null values

3. Check for data integrity. Data should be stored in single or multiple tables based on design

4. Index names should be given as per the standards e.g. IND__

5. Tables should have primary key column

6. Table columns should have description information available (except for audit columns like created date, created by etc.)

7. For every database add/update operation log should be added

8. Required table indexes should be created

9. Check if data is committed to database only when the operation is successfully completed

10. Data should be rolled back in case of failed transactions

11. Database name should be given as per the application type i.e. test, UAT, sandbox, live (though this is not a standard it is helpful for database maintenance)

12. Database logical names should be given according to database name (again this is not standard but helpful for DB maintenance)

13. Stored procedures should not be named with prefix “sp_”

14. Check is values for table audit columns (like createddate, createdby, updatedate, updatedby, isdeleted, deleteddate, deletedby etc.) are populated properly

15. Check if input data is not truncated while saving. Field length shown to user on page and in database schema should be same

16. Check numeric fields with minimum, maximum, and float values

17. Check numeric fields with negative values (for both acceptance and non-acceptance)

18. Check if radio button and dropdown list options are saved correctly in database

19. Check if database fields are designed with correct data type and data length

20. Check if all table constraints like Primary key, Foreign key etc. are implemented correctly

21. Test stored procedures and triggers with sample input data

22. Input field leading and trailing spaces should be truncated before committing data to database

23. Null values should not be allowed for Primary key column

24. Verify that data inserted from UI , is reflecting properly in appropriate table.

Tags :
database testing test casestest cases for database testing
how to write test cases for database testingmanual test cases for database testing
Manual test cases for penManual Test case for Email functionality
Database Testing tutorialsSQL Queries with example


  1. Nice Information about manual test cases for data base testing My sincere thanks for sharing this post Please Continue to share this post
    Selenium Training in Chennai

  2. You have been post an very useful information to our vision. which is used for me and many people who all are looking testing. keep sharing. Thank you...
    Selenium Training in Chennai | Software Testing Training in Chennai

  3. We all know that database files are highly prone to corruption due to its large size and complicated file structure. Like any other file, the SQLite database file is not immune to corruption.kpi dashboards

  4. Wow! That's really great information guys.I know lot of new things here. Really great contribution.Thank you ...

    software testing training

  5. Awe! What An Blog Very Helpful and interesting Really A great center for acquiring knowledge.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Food Service Parts .Really Thankfull For the blogger providing such a great information.Thank you. Have a Nice Day.

  6. This Blog is very helpful and useful,came to know that i should be strong in my basics and this blog helps me to improve it,School Physicals Chicago Services Provided by Us.Thanks For Posting.I Am refereed by my friend to this blog and i also want to refer my other friends to this blog.

  7. Thank you for sharing beneficial information nice post USMLE

  8. Thanks For Sharing Valuable Information, Very Useful For U digital transformation consulting

  9. Thanks for Gathering Great Information into One Post...

    Vizag Real Estate

  10. Now you can win free stuff online, free giveaways, enter every day to win latest iphones, smartphones, macbooks, laptops, accessories, technology and much more.

    Participate, Win & Keep A Free Apple iPhone XS Max

  11. Sickbits is a library of unlimited hacks for android, ios smartphones. Get unlimited amount of hacks and modes for mac & pc.