adspace


Explain acid?

Answer Posted / Ishan Ahmad

"ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These are properties that ensure reliable transactions in a database system: 1) Atomicity ensures that each transaction is treated as a single, indivisible unit of work. 2) Consistency guarantees that the database remains in a valid state before and after a transaction. 3) Isolation ensures that concurrent execution of transactions leaves the database in the same state as if they were executed sequentially. 4) Durability ensures that once committed, a transaction will survive permanent failures such as power outages."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is clustered index

1094


What is in place upgrade in sql server?

1137


How do I find query history in sql server?

1034


How can you append an identity column to a temporary table?

1078


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8239


How can I check that whether automatic statistic update is enabled or not?

1121


Can one drop a column from a table?

1098


What is the difference between upgrade and migration in sql server?

1193


Can you index views?

958


How to enter binary string literals in ms sql server?

1256


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1083


What is normalization and what are the advantages of it?

1067


What is subquery? Explain the properties of a subquery?

1070


How efficient you are in oracle and SQL server?

1269


How raid can influence database performance?

1127