Programming with Transactions Testing Commits and Rollbacks Almost all commercial-strength DBMS software supports the ability to undo the effects of a transaction before those effects are committed to the database. This is particularly useful when an operation must be performed to completion or not performed at all. You may undo these effects on the data using rollbacks. This portion of the exercise will familiarize you with rollbacks and commits.