• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

SoftwareTestingo - Interview Questions, Tutorial & Test Cases Template Examples

SoftwareTestingo - Interview Questions, Tutorial & Test Cases Template Examples

  • Home
  • Interview Questions
  • Java
  • Java Programs
  • Selenium
  • Selenium Programs
  • Manual Testing
  • Test Cases
  • Difference
  • Tools
  • SQL
  • Contact Us
  • Search
SoftwareTestingo » Manual Testing » Test Cases Example » Database Testing Test Cases

Database Testing Test Cases

Last Updated on: June 3, 2021 By Softwaretestingo Editorial Board

What We Are Learn On This Post

  • Database Testing Scenario

Database Testing Test Cases Example:

We will write some basic tests that must be performed on a database. As a tester, you need to validate the below test:

Test Scenario Overview
Post On: Test Case For Database Testing
Post Type: Test Case Template
Published On: www.softwaretestingo.com
Applicable For: Freshers & Experience

Database Testing Scenario

  • Check if correct data is getting saved in the database upon successful page submit for Database Testing
  • Check values for columns which are not accepting null values
  • Check for data integrity. Data should be stored in single or multiple tables based on design
  • Index names should be given as per the standards, e.g. IND_<Tablename>_<ColumnName>
  • Tables should have a primary key column
  • Table columns should have description information available (except for audit columns like created date, created by, etc.)
  • For every database add/update operation log should be added
  • Required table indexes should be created
  • Check if data is committed to the database only when the operation is completed
  • Data should be rolled back in case of failed transactions
  • 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)
  • Database logical names should be given according to database name (again this is not standard but helpful for DB maintenance)
  • Stored procedures should not be named with prefix “sp_.”
  • Check values for table audit columns (like created date, created by, updated date, updated by, isdeleted, deleteddate, deletedby, etc.) are populated properly
  • Check if input data is not truncated while saving. Field length shown to the user on a page and in database schema should be the same
  • Check numeric fields with minimum, maximum, and float values
  • Check numeric fields with negative values (for both acceptance and non-acceptance)
  • Check if radio button and dropdown list options are saved correctly in the database
  • Check if database fields are designed with the correct data type and data length
  • Check if all table constraints like a Primary key, Foreign key, etc. are implemented correctly
  • Test stored procedures and triggers with sample input data
  • Input field leading and trailing spaces should be truncated before committing data to the database
  • Null values should not be allowed for the Primary key column
  • Verify that data inserted from UI is reflecting properly in the appropriate table.
Tasks To Improve Your Knowledge
☑️ Database testing checklist ☑️ Database testing tools
☑️ Structural database testing ☑️ Database testing interview questions
☑️ Data testing techniques ☑️ Database testing course
☑️ Why database testing is important ☑️ Database testing pdf

** Let We Inform you that if you want to improve your knowledge then you can take the above as a task and work on this. You may found that some of the tasks we have completed you can refer that. After Completion if you want to share with us that then you can write to us at softwaretestingo.com@gmail.com.

In return for that maybe we plan something more surprising for your career.

If you found any missed test cases, then feel free to drop the test case in the comment section so that it will help us to give quality content, and also it helps the testers.

    Filed Under: Test Cases Example

    Reader Interactions

    Comments

    1. Avatar for ashraffashraff says

      February 6, 2022 at 11:34 AM

      Hai
      this is syed ashraff hussain i want data testing course .plz let me now how much fees u r charge. plz give me replay.

      Reply
      • Avatar for Softwaretestingo Editorial BoardSoftwaretestingo Editorial Board says

        February 6, 2022 at 1:50 PM

        Hi Sayed, currently we are not providing any courses

        Reply

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Primary Sidebar

    Join SoftwareTestingo Telegram Group

    Categories

    Copyright © 2022 SoftwareTestingo.com ~ Contact Us ~ Sitemap ~ Privacy Policy ~ Testing Careers