Write short notes on transaction state, Database Management System

Write short notes on transaction state?

A transaction may not always complete its implementation successfully such a transaction is termed aborted

A transaction must be in one of the following states

Active

Partially committed

Failed

Aborted

Committed

 

Posted Date: 6/3/2013 3:04:43 AM | Location : United States







Related Discussions:- Write short notes on transaction state, Assignment Help, Ask Question on Write short notes on transaction state, Get Answer, Expert's Help, Write short notes on transaction state Discussions

Write discussion on Write short notes on transaction state
Your posts are moderated
Related Questions
Construct a clean ans concise ER diagram for the database indicating the cardinality mapping for Employee management syatem

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Differentiate between B-tree and B + tree    Ans:  A B-tree (or Balanced Tree) is a search tree along with additional constraints that makes sure that the tree is all the time

a)  Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few

Drawbacks of Data Distribution: The primary drawbacks of distributed database systems are the added complexity needed to ensure proper coordination between the sites. This increas

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200

What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer. There are th


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