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
How does the system cope up with a record crash when recovery is going on after the first crash? Ans:  In a system the undo and redo operations are needed to be idempotent to c

Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

What is a primary index? A primary index is an index whose search key also explains the sequential order of the file.

Modify a sequence: ALTER SEQUENCE SEQSS INCREMENT 2 MAXVALUE 3000;   Removing a sequence: DROP SEQUENCE SEQSS;

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Explain the challenges before an E-business management.

differences between a classified catalog and a dictionary catalog

Define Query Processing Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to

Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s