Functionality: Database

Positive/Negative
Priority
# Test Case Positive/Negative Priority Author Vote
  1. Verify that data fields have correct data types and constraints applied in the database schema. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  2. Verify that correct data gets saved in the database upon successful page submission for Database Testing. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  3. Verify that insert/update query with null value for a not null column returns an error. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  4. Verify data integrity. Data should be stored in single or multiple tables based on design. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  5. Verify that the database schema is properly indexed. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  6. Verify that the database schema has only one Primary Key. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  7. Table columns should have description information available (except for audit columns like created date created by etc.). Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  8. Verify that insert update and delete query executions are logged properly. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  9. Verify that data is committed to the database only when the operation is completed. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  10. Verify that data is rolled back in case of failed transactions. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  11. Verify that logical naming convention is followed when naming database database schemas and columns. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  12. Verify that values for table audit columns (like created date created by updated date updated by isdeleted deleteddate deletedby etc.) are populated properly. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  13. Verify that proper data length is defined for each column in the database schema as per requirement. Length should be same as that in the field in the UI. Ensure input data is not truncated while saving. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  14. Verify input for numeric fields with minimum maximum and float values. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  15. Check numeric fields with negative values. depending on requirements some fields should not accept negative numbers. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  16. Verify that correct boolean value is saved in database for flags. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  17. Verify that values of radio buttons and checkboxes are saved propely in the database. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1
  18. Verify that leading and trailing spaces are truncated before committing data to the database. Positive p1 Milin Patel
Reviewed by Sanjay Kumar
Reviewed on 2022-09-08 04:56:10
1

Found any scenario missing? Login or sign up to contribute.