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

.