There are many times when in an application we need to fire multiple queries of add, update, remove, or all of them as a batch. In a batch of statements where multiple queries get fired against a database as a unit, all the queries should be successful or none of them. This is called transaction management. Transaction management is helpful in maintaining data consistency. In transaction management, it is not necessary that the queries should be fired against different tables in a database.
The following are the properties of a transaction:
Atomicity: When firing multiple queries, either all of them should be committed or none of them. This property makes sure that whatever operations are performed on the database and whenever any error occurs, no operations will be performed on the database.
Consistency: Before and after completing the transaction, the state of all the tables will be consistent. If any error occurs, the state of every table may vary. This leads to...