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
Is resultset an interface?
How many databases can we create in a single server?
which table keeps the locking information? : Sql server administration
How to download and install microsoft sql server management studio express?
What are the options which must be set to allow the usage of optimistic models?
Mention the differences between having and where clause.
Explain few examples of stored procedure over triggers?
Explain what is the main purpose of having conversation group?
Is there any difference between primary key and unique with the not null condition?
What is cached report?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Please explain what is “asynchronous” communication in sql server service broker?
Who developed sql server?
What sql server means?
How you would rewrite the sql query to return the customerid sorted numerically?