SQL Transactions

What are Transactions?

The ACID properties of SQL Transactions, What are the different ACID properties of a transaction how they ensure that data is Atomic, Consistent, Isolated, and Durable.

Transactions and Errors

SQL Transaction and Error Handling? What is the difference between Auto-Commit and Explicit Transactions and how transaction affect Errors and Exception Handling?