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
What happens when the SQL Azure database reaches Max Size?
How many partitions a clustered index has by default in sql server 2012?
What is default constraint in ms sql server?
What's the information that can be stored inside a bit column?
How to create a Master database in SQL server ?
Explain indexed views and partitioned view with their syntax.
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are the different types of collation sensitivity in sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is tempdb database? : SQL Server Architecture
how to create a scrollable cursor with the scroll option? : Sql server database administration
How to return the top 5 rows from a select query in ms sql server?
Explain what is cte (common table expression)?
Why functions are used in sql server?
What is inner join? Explain with an example?