Isolation => I in ACID
Supported two types:
- Read Committed
- Serializable
However, there are other levels of ISOLATION such as:
Read Uncommitted
Repeated READ
—
Note: in Read Committed, dirty data is locked until committed.
In Repeated Read, A row (being modified) is locked until committed.
In Serializable, A block/dataset/table (being modified) is locked until Serialization Terminated.
TCL/Transaction Control Language Commands
COMMIT
SET AUTOCOMMIT OFF/ON
ROLLBACK
SAVEPOINT
ROLLBACK TO SAVEPOINT
