Full width home advertisement

Welcome Home

Post Page Advertisement [Top]

What is Transaction Failure in DBMS?

Transaction Failure is when certain processes have to abort when it fails to carry out or when it reaches a point from where it can’t go any further or when some transactions or processes have errors.  

Reasons for a transaction failure:

1. Logical errors: Where a transaction cannot finish because it has some code error or critical internal error.

2. System errors: Where the database system itself terminates an active transaction because the DBMS is not able to execute it, or it has to stop because of some system circumstance. For instance, in case of deadlock or resource unavailability, the system aborts an active transaction.

What is Deadlock in DBMS?

Deadlock or hanging is an critical condition that arises in a shared resource environment, where a process indefinitely waits for a resource that is held up by another running process in a multi-process system.

No comments:

Post a Comment

Bottom Ad [Post Page]