How can a user test Transactions in an SQL database?

This requires the ACID properties, and to achieve that we use the following statements-

Using the ROLLBACK command changes are rolled back to the previous commit. Once transactions are executed, the user can use SELECT queries to validate the data.

Example