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
Mixed fragmentation: Sometimes, horizontal fragmentation or vertical fragmentation of a database schema by itself is insufficient to sufficiently distribute the data for some appli

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)

Suppose an instruction takes 1 nanosecond to execute (on average), a page fault takes 20 microseconds of processor time, and it takes 300 microseconds of disk time to read or write

Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

please give me introduction to full data in D B M S in a short assignment

State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

Consider the following relational database: STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course#, sem

Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

Explain the three data models namely relational, network and hierarchical and evaluate their relative advantages and disadvantages. Hierarchical Model: In hierarchical model, da

Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID