Answer Posted / vishal
Atomicity means either the transaction is complete or it it will go on its previous condition
consistency :- it means that after and before the transaction process the data remains in consistent manner;
Isolation :- if two transaction process than each transaction is unaware to both of them
Durability :-means when the transaction is committed .it must be durable even the system is crash..
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How you can find out if an index is useful to the optimizer?
‘Order by’ is not allowed in a view how can you sort information from a view?
Explain what are the restrictions while creating batches in sql server?
What is query optimization process?
can any body tell me how to know the password of current user in sql server
What do you need to connect php to sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases?
Explain the collation?
How sql server executes a statement with nested subqueries?
What does it mean to invest in the index?
How to create a trigger for insert only?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to specify the collation for a character data type in ms sql server?
Explain what is sql server english query?
What does <> symbol mean?