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
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 ? Logical Data Independence - It is the capacity to modify the conceptual schema without having to change external schemas or application p

what is view?explain

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

composite attribute

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? 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

entity relationship diagram for online examination system

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