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.
SQL Transaction and Error Handling? What is the difference between Auto-Commit and Explicit Transactions and how transaction effect Errors and Exception Handling?
What is a Lock? What is the process that transactions use to lock records to provide transaction isolation.