WEEK 6 : Transaction Management

Question 1

What is Transaction Management?

Answer 1

A procedure consisting of one or several SQL statements that must be entirely completed or is will be aborted.

Question 2

What are the properties of a transaction?

Answer 2

ACID - Atomicity, Consistency, Isolation and Durability.

Question 3

What is Atomicity?

Answer 3

All operations of the transaction must be completed and if not it is aborted.

Question 4

What is Consistency?

Answer 4

The transaction must take the database from one consistent state to another.

Question 5

What is Isolation?

Answer 5

The data of the first transaction cannot be used in the second one, until the first is completed.

Question 6

What is Durability?

Answer 6

Once a transaction is completed its changes are persistent and survives system failures.

Question 7

What is a transaction log?

Answer 7

A system maintained table that records information on the changes made in the user tables.

Question 8

What are the column names of a transaction log?

Answer 8

logId, transId, operation, table, rowId, columnName, before and after