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
Explain can SSRS reports Cache results?
What is query optimization process?
What is the most common type of join?
What is oltp (online transaction processing)?
Can select statements be used on views in ms sql server?
What are commonly used odbc functions in php?
What is lock escalation? : sql server database administration
How ssrs maintain security?
What are sql dirty pages?
Does index speed up select statements?
Why union all is faster than union?
Difference between 2NF &3NF ?
How to convert numeric values to integers in ms sql server?
Explain database normalization?
What is the purpose of grouping data in a report?