What is transaction ? Give me one example.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to defragment indexes with alter index ... Reorganize?

560


When would you use a before or after trigger?

472


What is a transactions?

586


How to view the error log for any specific instance? : sql server database administration

559


Write an sql query to find first weekday of the month?

464






Can sql servers linked to other servers like oracle?

519


What are logical/boolean operations in ms sql server?

523


Why do we use sql limitations? Which constraints can we use while making a database in sql?

541


How do I find sql server instance name?

484


How do I find the port number for sql server?

487


How to delete duplicate records based on single column from a table?

577


Can we do dml on views?

530


How many types of schemas are there?

509


When I run the sql server 2000 setup, it just hangs. What do I do?

626


What is Cross Join and in which scenario do we use Cross Join?

550