Question

Which of the following is true about SQLite transactions?

a) Transactions are not supported in SQLite.

b) A transaction is a sequence of SQL statements that are executed as a single unit of work.

c) A transaction can be rolled back if any of the SQL statements in the transaction fail.

d) All of the above.

Answer 1

Answer: b) A transaction is a sequence of SQL statements that are executed as a single unit of work.

Explanation: SQLite supports transactions, and a transaction is a sequence of SQL statements that are executed as a single unit of work. If any of the SQL statements in the transaction fail, the transaction can be rolled back to the point before it started.