1. What are the ACID properties?
APRIL/MAY-2011
(atomicity, consistency,
isolation, durability) is a set of properties that guarantee database
transactions are processed reliably.
In the context of databases, a single logical operation on the data is called a
transaction. For example, a transfer of funds from one bank account to another,
even though that might involve multiple changes (such as debiting one account
and crediting another), is a single transaction.
2. What are two pitfalls (problem)
of lock-based protocols? APRIL/MAY-2011
Ø Deadlock
Ø Starvation
3. What is transaction?
Collections of operations that form
a single logical unit of work are called transactions.
4. What are the two statements
regarding transaction?
The two statements regarding
transaction of the form:
Ø Begin transaction
Ø End transaction
5. What are the properties of
transaction?
The properties o f transactions are:
Ø Atomicity
Ø Consistency
Ø Isolation
Ø Durability
