What is the test content of database testing?

Test contents of database testing: 1. Database connection test; 2. Database robustness, fault tolerance and recovery ability test; 3. Database security test; 4. Database performance test; 5. Database Capacity testing; 6. Testing of database objects; 7. Database interface testing; 8. Adding and deleting data items; 9. Adding data tables, etc.

The operating environment of this tutorial: Windows 7 system, Dell G3 computer.

The main test content of database testing

Database testing generally includes:

1. Database connection test

2. Database Robustness, fault tolerance and recovery capability testing

3. Database security testing

4. Database performance testing

5. Database capacity testing

6. Testing of database objects, including defined stored procedures, views, triggers, constraints, rules, etc., must be tested to ensure that the functions are intact

7. Database interface testing, including modification of data items Operation

8. Add and delete data items

9. Add data table to full

10. Delete empty data table

11. Delete empty space Records in the table

12. Concurrent operations of the data table

In addition: for the interface test of the stored procedure, combined with the business logic to do the interface test of the associated table, we also need to consider using these interfaces Equivalence classes, boundary values, error guessing, etc. are tested.

For more related knowledge, please visit the FAQ column!

The above is the detailed content of What is the test content of database testing?. For more information, please follow other related articles on the PHP Chinese website!