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

Ask an Expert

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

Write your message here..

Related Questions

ER diagram, Construct a clean ans concise ER diagram for the database indic... Construct a clean ans concise ER diagram for the database indicating the cardinality mapping for Employee management syatem

Define database management system, Normal 0 false false fal... Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Differentiate between b-tree and b+ tree, Differentiate between B-tree and ... 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

Ways to suggest the dba, a)  Suppose we updated the catalog tables in real ... 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

Higher software development cost, Drawbacks of Data Distribution: The prim... 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, How do you find t... 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-problems of concurrent transactions, Dirty Reads: T10 reads a ... 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 relation, What are the ... 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

Systems Analysis and design, Homework chapter 10 no 3 Homework chapter 10 no 3

What is deadlock, What is deadlock? How can it be avoided? How can it be re... 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