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


BY Best Interview Question ON 09 Feb 2019