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
How to defragment indexes with alter index ... Reorganize?
When would you use a before or after trigger?
What is a transactions?
How to view the error log for any specific instance? : sql server database administration
Write an sql query to find first weekday of the month?
Can sql servers linked to other servers like oracle?
What are logical/boolean operations in ms sql server?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How do I find sql server instance name?
How do I find the port number for sql server?
How to delete duplicate records based on single column from a table?
Can we do dml on views?
How many types of schemas are there?
When I run the sql server 2000 setup, it just hangs. What do I do?
What is Cross Join and in which scenario do we use Cross Join?