What is deadlock, Database Management System

What is deadlock? How can it be avoided? How can it be resolved once it occurs?

Deadlock happens when two transactions are each waiting on a resource that the other transaction holds. Deadlock can be stooped by requiring transactions to acquire all locks at the similar time; once it happens, the only way to cure it is to abort one of the transactions and back out of partially completed work.

 

Posted Date: 7/4/2013 9:08:47 AM | Location : United States







Related Discussions:- What is deadlock, Assignment Help, Ask Question on What is deadlock, Get Answer, Expert's Help, What is deadlock Discussions

Write discussion on What is deadlock
Your posts are moderated
Related Questions
What is first normal form? The domain of attribute must contain only atomic (simple, indivisible) values.

Define the Traditional System Analysis and Design Traditional System Analysis and Design (SAD) have three basic life cycle models. A typical software lifecycle consists of the

The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

what is inverted and multilist structure

What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.


Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

What is the need for triggers? Triggers are useful mechanisms for alerting humans or for starting particular tasks automatically when particular conditions are met.

For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should conta