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.


like,

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
Consistency
Isolation and
Durability

Is This Answer Correct ?    18 Yes 4 No

What is transaction ? Give me one example...

Answer / senthilsjc

Hai..

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.

By
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

Atomic
Constistence
Isolation
Durabulity

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.
Regards:
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

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,


How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,


What are different types of replication in sql server?

0 Answers  


Explain the creation and execution of a user-defined function in the sql server?

0 Answers  


How to rename an existing column with sql server management studio?

0 Answers  






Define indexes?

0 Answers  


What is ms sql server service broker?

0 Answers  


Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  


Why is replication required on the sql server?

0 Answers  


Can we create clustered index on non primary key column

20 Answers   ABC, CTS,


What are alternate keys?

0 Answers  


Explain what is it unwise to create wide clustered index keys?

0 Answers  


Categories