What are the SQLite transactions?
In SQLite, the transaction is mentioned as a unit of work performed against a database. The properties of a transaction are determined by four factors also called ACID.
- Atomicity: Ensures work of units to be completed successfully.
- Consistency: Ensures the states of database change after every successful transaction.
- Isolation: This enables SQLite transactions to operate independently and transparent to each other.
- Durability: This ensures the effect of committed transactions stays in case of system failure.
This question has always been a center of the discussion in SQLite Interview Question Android