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 are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));


Give an example of operations from the State Actions and Activities. For instance, in bank the activity verify account code and verify password

Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical

What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

Creating a view: A query can be embedded within the CREATE VIEW STATEMENT A query can have complex select statements containing join, groups and sub- queries A quer

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

what is object-identity