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

Ask an Expert

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

Write your message here..

Related Questions

Describe file organisation, Describe file organisation? A file is organ... Describe file organisation? A file is organized logically as a sequence of records. These records are mapped onto disk blocks. A) Fixed-Length Records Type deposit=record

Describe logical data independence, Describe logical data independence ? ... Describe logical data independence ? Logical Data Independence - It is the capacity to modify the conceptual schema without having to change external schemas or application p

Views, what is view?explain what is view?explain

Describe different steps of object-oriented design process, Describe differ... Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system

Single-valued dependencies, Single-Valued Dependencies A database is a ... Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some

Attribute, composite attribute composite attribute

Explain trivial dependency, Explain trivial dependency? Functional depe... Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.

What is aggregate function, What is aggregate function? Briefly describe it... What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre

Online examination system project, entity relationship diagram for online e... entity relationship diagram for online examination system

What is a linked server, What is a Linked Server? Linked Servers is a m... What is a Linked Server? Linked Servers is a method in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With