what’s a transaction in dbms

content

a transaction is a sequence of operations
- operations might involve reading, writing, updating, deleting
- when user performs a transaction, it might involve reading, writing, updating, deleting
a transaction is the unit of work
source: Transaction in DBMS - GeeksforGeeks
a transaction has to be rollback or commit
- otherwise, connections in connection pool might run out!