What is transaction ? Give me one example.
- 11 Answers
- 25186 Views
- Melstar, Wipro, I also Faced
- E-Mail Answers
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
Can you force a query to use a specific index?
what method you can use to reduce the overhead of Reporting Services data sources?
can any body tell me how to know the password of current user in sql server
What is policy based management (pbm)? : sql server database administration
How to insert data into an existing table?
What is the function of inner join?
Is null in sql server?
How to view the error log for any specific instance? : sql server database administration
What is store procedure? How do they work?
Introduction of rollup clause using sum and group by clause?
What happens to a trigger with multiple affected rows?
What is sqlcmd?
List some advantages and disadvantages of stored procedure?
What are the encryption mechanisms in sql server?
Explain different types of index?
