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
Given the following relations Vehicle (Reg_no, make, colour) Person(eno, name, address) Owner(eno, reg_no) Write expressions in the relational algebra to answer the following

A database has been designed for this beauty parlour in order for the staff to manage specific things such as bookings made by clients, payments, staff availability, level of exper

1) Information about a bank is about customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac

create an er diagram for production management in film industry

Read the description below and draw an Entity-Relationship diagram for it. You must use the symbols described in the course materials. This database will help the Parents Assocc

Define Query by Example QBE is a query language relies upon domain calculus and has two dimensional syntax. The queries are written in the horizontal and vertical dimensions of

Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

What is a Built-in A notation of identity is built-into the data model or programming language and no user-supplied identifier is needed. This form of identity is used in objec

What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa