Transactions and Concurrency - General Questions

Its result equals some serial execution of the same transactions

It has no reads

It uses no locks

Transactions run one at a time

Accuracy, Concurrency, Integrity, Data

Atomicity, Consistency, Isolation, Durability

Access, Control, Isolation, Data

Atomicity, Concurrency, Integrity, Durability

No log is kept

Logs are written after commit only

Data is written before the log

Log records are written before the data changes reach disk

Immediately after each write

At random

Before the growing phase

Only after the transaction commits or aborts

Undo the changes of the current transaction

Start a new database

Delete a table

Save changes permanently