wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform
Answer Posted / praveen
Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions)
Consistent (data is either committed or roll back, no
“in-between” case where something has been updated and
something hasn’t)
Isolated (no transaction sees the intermediate results of
the current transaction)
Durable (the values persist if the data had been committed
even if the system crashes right after).
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain the concepts and capabilities of sql server?
What are different types of data sources?
When to use Inner join & when to use subquery?
Write a SQL query to make a column as unique?
Write a query to find 5th highest amount paid from the customer table.
What is the difference between set and select?
What is difference between foreign key and unique key?
What are different types of collation sensitivity?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Explain steps of normalization?
What are the general features of sql server management studio? : sql server management studio
How many categories of functions based their return modes?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is schemabinding a view?
How do I perform an unattended install of sql server 2000?