database checkpoints

[sangeethakumar]

explain in detail about database checkpoints

[Adrian]

By adding runtime database record checkpoints you can compare the information in your application during a test run with the corresponding record in your database. By adding standard database checkpoints to your test scripts, you can check the contents of databases in different versions of your application.

[rachelle]

The database checkpoint guarantees that all changes in all enabled threads prior to the database checkpoint have been written to disk.Checkpoints are recorded in the control file.Database checkpoints can be used in the test scripts to check databases in your application and the defects can be traced. You define a query on the database and then create a database checkpoint that checks the properties of the results of the query. When you check these properties, you can check the contents of the results or how many rows or columns the results contains.