What is ACID?

Answer Posted / gurmeet shah

Atomicity,Consistency,Isolation,Durability

Atomicity:
1. a transaction is a unit of operation - either all the
transaction's actions are completed or none are
2 atomicity is maintained in the presence of deadlocks.

Consistency: Consistency is the ACID property that ensures
that any changes to values in an instance are consistent
with changes to other values in the same instance

Isolations: The isolation portion of the ACID properties is
needed when there are concurrent transactions. Concurrent
transactions are transactions that occur at the same time

Durability:It refers to the ability of the system to
recover committed transaction updates if either the system
or the storage media fails.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I know if mysql is installed on windows?

477


What is mysql command line?

500


What is the default port for MySQL Server?

572


What is a mysql server?

512


How do I rename a table in mysql workbench?

497






Can you rename a database in mysql?

527


How can you make a database as your current database?

500


What are the other commands to know the structure of a table using mysql commands except explain command?

538


What is difference between microsoft sql and mysql?

489


Is mysql a server?

465


What is the phantom problem?

496


Can not connect to mysql server 10060?

496


Write a program using the select statement, while loop.

465


What is mvcc in mysql?

526


Where is the mysql data directory?

495