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
QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

Explain different categories of failures that occur in Oracle database? Categories of Failures - In Oracle database subsequent types of failures can occurred: Statement Failu

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Determine the Advanced modeling concepts You have to follow some steps for object-oriented design. These steps for OO Design methodology are as follow:  1)  Produce objec

Write a short note on oracle Instance? Oracle Instances: An instance is the (executed) Oracle software and the memory they use. It is the instance which manipulates the data s

Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or


Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

We have a new website where I need someone to 1: Inhabit the back end with all the recruitment agencies in the UK. I require someone who is not manually going to do this, but who w

Prepare Heart Failure Registry database How are you today? Please I would like you to design a Heart Failure registry where doctors will log in to enter information about their