The Gateway to Computer Science Excellence
+2 votes
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 | 201 views

3 Answers

0 votes
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

0 votes
Check ACID property,deadlock is the answer.

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
52,375 questions
60,574 answers
95,389 users