What is transaction ? Give me one example.

Answers were Sorted based on User's Feedback

What is transaction ? Give me one example...

Answer / nirmala.s

transaction is series of actions that should happen without
any fail.
if the transaction consists of 3 actions , if anyone of
these fails, then whole transaction wil be rolled back.


banking: we used to say it as a transaction.
logging in, transfer fund and logging out.
if any one of these fails ,
the transaction will not be completed.

Is This Answer Correct ?    44 Yes 9 No

What is transaction ? Give me one example...

Answer / geetanjali

Well kumar u r right but in ACID Property
A stands Atomicity not Acit
Remaining are correct.

Is This Answer Correct ?    19 Yes 4 No

What is transaction ? Give me one example...

Answer / mobin sathupally

A transaction is a logical unit of work, it ensures that
multiple data modifications are procecessed together.
A transaction follows four properties(rules).
Those properties are "ACID".
ACID stands for Automocity
Isolation and

Is This Answer Correct ?    18 Yes 4 No

What is transaction ? Give me one example...

Answer / senthilsjc


plz understand what they asked?
don't post answer what u studied in material..

if u know well with example post it..

plz don't waste ur time and others?

Is This Answer Correct ?    17 Yes 4 No

What is transaction ? Give me one example...

Answer / kumar

Transaction is logical unit of work. It will be done all
the things must otherwise none.
It Should be Satisfy ACID Property.
A - Acit
C - Consistency
I - Isolation
D - Durability.

Kumar T

Is This Answer Correct ?    24 Yes 16 No

What is transaction ? Give me one example...

Answer / ashique

Transaction is a database operation that satisfies following
a condition called ACID:

A (Atomicity) : Do all the operations successfully Or None.
C (Consistency) : The operation should not violate data
integrity concept.
I (Isolation) : When one person is manipulating the data,
others should wait (i.e synchronization).
D (Durability): Once transaction is over succesfully, the
changes should be permanent at any cost.

The best example of a simple transaction is bank fund
transfer from one account to another. Try to implement above
points using your common sense. Thank you :)

Is This Answer Correct ?    11 Yes 3 No

What is transaction ? Give me one example...

Answer / hari

Transcation is sequence of operations performaed a single
logical unit of work


Is This Answer Correct ?    12 Yes 8 No

What is transaction ? Give me one example...

Answer / shoaib aatish

Transaction is accrue between tow parties like any business-related exchange such as Payments to employees, Sales to customers and payments to the suppliers. Thus, processing business transaction was the first application of computer for most organizations.
Shoaib Aatish from MSC CS, UAF, FSD

Is This Answer Correct ?    2 Yes 2 No

What is transaction ? Give me one example...

Answer / raj

Transaction is a daily routine work in companies, it is a
part of data that is stored daily, for example banking in
which data is stored daily.

Is This Answer Correct ?    2 Yes 3 No

What is transaction ? Give me one example...

Answer / mr.narendra singh(gulli)

transction is a process use for either execution or set
of exection process complite or abort or rollback.
Ex-ATM(alternative transation machine),railway reservation
and so on.

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More SQL Server Interview Questions

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

how to find out the repeated value from table using groupby function?

4 Answers  

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,

how can i store resumes in database?

3 Answers   HCL,

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

Define Check points and End Points?

1 Answers  

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

15 Answers   Accenture, IBM, Marlabs,

If there is failure during updation of certain rows, what will be the state?

2 Answers  

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers