Filters
Positive / Negative
Priority
Tags
Functionality: Database
| # | Test Case | +ve/-ve | Priority | Author | Vote | |
|---|---|---|---|---|---|---|
| 1. | Verify that data fields have correct data types and constraints applied in the database schema. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 2. | Verify that correct data gets saved in the database upon successful page submission for Database Testing. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 3. | Verify that insert/update query with null value for a not null column returns an error. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 4. | Verify data integrity. Data should be stored in single or multiple tables based on design. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 5. | Verify that the database schema is properly indexed. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 6. | Verify that the database schema has only one Primary Key. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 7. | Table columns should have description information available (except for audit columns like created date created by etc.). | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 8. | Verify that insert update and delete query executions are logged properly. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 9. | Verify that data is committed to the database only when the operation is completed. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 10. | Verify that data is rolled back in case of failed transactions. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 11. | Verify that logical naming convention is followed when naming database database schemas and columns. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
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 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
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 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 14. | Verify input for numeric fields with minimum maximum and float values. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 15. | Check numeric fields with negative values. depending on requirements some fields should not accept negative numbers. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 16. | Verify that correct boolean value is saved in database for flags. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 17. | Verify that values of radio buttons and checkboxes are saved propely in the database. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
|
| 18. | Verify that leading and trailing spaces are truncated before committing data to the database. | Positive | p1 |
Reviewed by Sanjay Kumar
Reviewed on 2022-10-05 12:27:32
|
1
|
New Functionalities