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

logshipping is Any difference 2000 and 2005?

2 Answers  


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  


What is Peer to peer Replication?

1 Answers   HCL, CarrizalSoft Technologies,


What is Full Outer Join?

3 Answers  


what is package and it uses and how can u call a package

0 Answers   Satyam,






Can some one please help with a query which will take only max value of a column in a join.

2 Answers  


What is an index?

8 Answers   Yardi Software,


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  


Working with TLogs

0 Answers  


How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,


sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  


what are the limitations of parameters in a storedprocedure

1 Answers  






Categories