1.

What is the role of the Index in SQLite?

Answer»

Indexes are the lookup tables which are used by the database ENGINES to speed up the process of retrieving of the data. We can say that the Index is a pointer to the data in a table.

12. 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

.


Discussion

No Comment Found

Related InterviewSolutions