What is transaction ? Give me one example.
- 11 Answers
- 25697 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
How sql server enhances scalability of the database system?
What is “asynchronous” communication in sql server service broker?
How to connect Azure federated root database and apply federation in entity framework?
List the different index configurations possible for a table?
How can you tell if a database object is invalid?
Can you pass expressions to function parameters?
What are the system database in sql server 2008?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Explain the xml support sql server extends?
How do clustered indexes store data?
What is the difference between delete and truncate statements?
what is a deadlock? : Sql server database administration
Can I save my report as html, excel or word? : sql server management studio
Explain cursor as data base object?
What are the different types of replication are there in sql server 2000?
