Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / patil madhav
Atomicity:-
All changes to data are performed as if they are a
single operation. That is, all the changes are performed, or
none of them are.
For example, in an application that transfers funds from
one account to another, the atomicity property ensures that,
if a debit is made successfully from one account, the
corresponding credit is made to the other account.
Consistency:-
Data is in a consistent state when a transaction starts
and when it ends.
For example, in an application that transfers funds from
one account to another, the consistency property ensures
that the total value of funds in both the accounts is the
same at the start and end of each transaction.
Isolation:-
The intermediate state of a transaction is invisible to
other transactions. As a result, transactions that run
concurrently appear to be serialized.
For example, in an application that transfers funds from
one account to another, the isolation property ensures that
another transaction sees the transferred funds in one
account or the other, but not in both, nor in neither.
Durability:-
After a transaction successfully completes, changes to
data persist and are not undone, even in the event of a
system failure.
For example, in an application that transfers funds from
one account to another, the durability property ensures that
the changes made to each account will not be reversed.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the maximum row of a size?
What is dml command?
What are relationships and mention different types of relationships in the dbms
Can primary key be null?
how you can get the list of largest tables in a database? : Sql server administration
What are the purposes of floor and sign functions?
Can foreign key be duplicate?
List out the differences between global and local temp tables in sql server?
How check triggers in sql server?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How to update muliple row in single query?
What does executeupdate return?
How many instances per computer are there in sql server 2000?
Explain the phases a transaction has to undergo?
Why we should not use triggers?
