Memory-Interfacing
February 11, 2025TNPSC-2012-Polytechnic-CS
February 13, 2025ACID-properties
| Question 4 |
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 4 Explanation:
Irrecoverable error occurs when a transaction reads a data item after it is written by uncommitted transaction.
An irrecoverable error is an error that remains an error, no matter how many times you try to perform the same action. In the integration space, that could mean trying to access a database table that does not exist, which would cause the JDBC driver to throw back a SQLException
An irrecoverable error is an error that remains an error, no matter how many times you try to perform the same action. In the integration space, that could mean trying to access a database table that does not exist, which would cause the JDBC driver to throw back a SQLException
Correct Answer: D
Question 4 Explanation:
Irrecoverable error occurs when a transaction reads a data item after it is written by uncommitted transaction.
An irrecoverable error is an error that remains an error, no matter how many times you try to perform the same action. In the integration space, that could mean trying to access a database table that does not exist, which would cause the JDBC driver to throw back a SQLException
An irrecoverable error is an error that remains an error, no matter how many times you try to perform the same action. In the integration space, that could mean trying to access a database table that does not exist, which would cause the JDBC driver to throw back a SQLException