You can use an application to retrieve data from a database or to insert data into the
database. Database checkpoints in a test enable you to ensure that the application
successfully retrieves or inserts data into a database.
A database checkpoint stores the expected data and compares the expected data with the
data stored in the database. You use a database checkpoint to confirm that the data
stored in a database has not introduced errors in the application.
When executing a database checkpoint, the following events occur:
1. The test arrives at the database checkpoint step and connects to the database.
2. QuickTest sends a query to the database to retrieve the actual data.
3. QuickTest gathers the result set of the query, which provides the actual data.
4. QuickTest compares the actual data with the expected data, which is stored in the database checkpoint, to determine if the test passed or failed.