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 many types of indexes are there in mysql?

555


What is datadir?

550


How to create a new table in mysql?

619


Why use mysql procedures?

588


How do I show all mysql databases?

589






What is mysql vs sql?

580


What is user in mysql?

513


What is max connections in mysql?

577


How many columns can a table have?

555


Does mysql use sql?

563


What, if a table has one column defined as TIMESTAMP?

638


Can mysql store files?

578


What you can use regular expression for in mysql?

571


What is 'mysqladmin' in mysql?

617


How to drop an existing index in mysql?

662