What is transaction ? Give me one example.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the properties of sub-query?

677


What triggers long term care?

638


What are the reporting services components?

100


How to populate a table in sql server?

592


Can we delete data from a view?

626






Which are new data types introduced in sql server 2008?

710


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

675


What are triggers? How do you invoke a trigger on demand?

843


What are the key configuration files for sql server reporting services ?

128


How you can move data or databases between servers and databases in sql server?

656


Why should one not prefix user stored procedures with ‘sp_’?

695


What is parameterized reports in ssrs ?

111


What is the difference between a function and a trigger?

674


Define Unique Key?

678


What is a heap?

699