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
Can group functions be mixed with non-group selection fields in ms sql server?
what happens on checkpoint? : Sql server database administration
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is the New in SQL server 2008?
What is the difference between the 2 operating modes of database mirroring?
What is dirty page?
What are the commands used in DCL?
What is the difference between a function and a stored procedure?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is transactional replication?
What are sp_configure commands and set commands?
Does server sql treat char as a variable-length or fixed-length column?
What do you mean by 'normalization'?
what is the system function to get the current user's user id? : Sql server database administration
What is the openxml statement in sql server?
