What are the main test contents of database testing

This article mainly introduces the main test content of the database test, the article is very detailed, has a certain reference value, interested friends must read it!

The test content of database test: 1, database connection test; 2, database robustness, fault tolerance and resilience test; 3, database security test; 4, database performance test; 5, database capacity test; 6, database object test; 7, database interface test; 8, data item addition, deletion operation; 9, data table addition, etc.

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

The main test contents of database testing

Database tests generally include:

1. Database connection test

two。 Testing of database robustness, fault tolerance and resilience

3. Security testing of Database

4. Performance Test of Database

5. Capacity test of database

6. Testing of database objects, including defined stored procedures, views, triggers, constraints, rules, etc., should be tested to ensure functional integrity

7. Database interface testing, including modification of data items

8. Operation of adding and deleting data items

9. The data table is full.

10. Delete empty datasheet

11. Delete records in an empty table

twelve。 Concurrent operation of data table

In addition: for the interface testing of stored procedures, combined with business logic to test the interface of the associated table, we also need to consider the use of equivalence classes, boundary values, error guessing and other methods to test these interfaces.

These are all the contents of the article "what are the main contents of database testing?" Thank you for your reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!