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

Is port 1433 secure?

734


How to create a view using data from another view?

728


What is the difference between a primary key and a unique key? Are they the same?

776


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

113


How will you optimize a stored procedure optimization?

676






What is db stored procedure?

614


How to make a remote connection in a database?

705


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

672


What is index in an assignment?

695


What are the High-Availability solutions in SQL Server and differentiate them briefly?

896


What are database states in ms sql server?

828


Do you know spatial data types - geometry and geography in sql server 2008?

765


How can we rewrite sub-queries into simple select statements or with joins?

705


What is the difference between insensitive and scroll cursor?

756


Tell me what is the difference between locking and multi-versioning?

757