Explain SQLite transactions and its properties?

devquora
devquora

Posted On: Feb 22, 2018

 

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQLite interview questions

    What is SQLite and where is it used?

    The SQLite is mostly ACID (Atomicity, Consistency, Isolation, and Durability) compliant relational database management ..

    SQLite interview questions

    Distinguish between SQLite and SQL?

    SQLite: It is a well built, embedded relational database management system that is mostly used in mobile devices for da..

    SQLite interview questions

    Mention some SQLite commands and also explain them?

    The SQLite commands interact directly with relational databases and are similar to SQL. Below are the standard SQLite c..