Google News
logo
SQLite - Interview Questions
Explain SQLite transactions and its properties?
The transaction is actually referred to the unit of work that is performed against a database. The SQLite transactions are the propagation of one or more changes to the database.

The properties of transactions are determined by ACID compliance.

* Atomicity : This property ensures that the entire work unit is completed successfully.

* Consistency :
This property ensures that the database changes its state upon a successfully committed transaction.

* Isolation :
This property ensures that the transactions are operated independently and are transparent to each other.

* Durability :
This property ensures that the result or effect of a committed transaction will persist in case of system failure.
Advertisement