The Gateway to Computer Science Excellence
+2 votes
170 views
Which of the following is not a cause of transaction failure?

1. System Crash
2. Deadlock
3. Exception
4. All of the above are causes of transaction failures
in Databases by (249 points) | 170 views

3 Answers

0 votes
deadlock
by (23 points)
0 votes

System crash – A hardware, software, or network error may cause a computer to fail or hang during an ongoing transaction.

exception – A transaction may be failed if necessary data not found, or an exception condition met. For example, customer A tries to purchase an item online. Assume that only two such items are available when A starts his transaction and both of them purchased by other customers. When A reaches end of the transaction, the items are not available hence the transaction is cancelled or failed.

so i think deadlock is ans

by Active (4.5k points)
0 votes
Check ACID property,deadlock is the answer.
by Active (3.1k points)

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,644 questions
56,507 answers
195,558 comments
101,061 users