Transactions t1 and t2 are in a deadlock, Database Management System

Evaluate:

a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation.

b. When an inform to the database takes place, the time of the update, the values of the data previous to and after the update, and the type of lock used are recorded in the transaction log.

c. To restore a database using the instant update approach, both undo and redo operations may be essential, while with the deferred update approach only redo operations are used.

 

Posted Date: 3/20/2013 7:45:17 AM | Location : United States







Related Discussions:- Transactions t1 and t2 are in a deadlock, Assignment Help, Ask Question on Transactions t1 and t2 are in a deadlock, Get Answer, Expert's Help, Transactions t1 and t2 are in a deadlock Discussions

Write discussion on Transactions t1 and t2 are in a deadlock
Your posts are moderated
Related Questions
What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano

The cross-section of twisted pair The cross-section of each and every strand of the twisted pair is π/4 square mm. A 10-km length of this type of material, with two strands per

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

A student entity type has the following attributes,name..

What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures

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

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

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