Database-Management-System
October 4, 2023Normalization
October 4, 2023Transactions
|
Question 5
|
Which of the following scenarios may lead to an irrecoverable error in a database system?
|
A transaction writes a data item after it is read by an uncommitted transaction
|
|
|
A transaction reads a data item after it is read by an uncommitted transaction
|
|
|
A transaction reads a data item after it is written by a committed transaction
|
|
|
A transaction reads a data item after it is written by an uncommitted transaction
|
Question 5 Explanation:
Irrecoverable error occurs when a transaction reads a data item after it is written by uncommitted transaction.
Correct Answer: D
Question 5 Explanation:
Irrecoverable error occurs when a transaction reads a data item after it is written by uncommitted transaction.