What is ACID?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amith
Automicity transactions are atomic and should be treated
as one in case of rollback. Consistency - the database
should be in consistent state between multiple states in
transaction.
Isolation no other queries can access the data modified by
a running transaction. Durability system crashes should not
lose the data.
Is This Answer Correct ? | 2 Yes | 0 No |
What is delimiter in mysql?
How many sql dml commands are supported by 'mysql'?
What storage engines are used in MySQL?
What is foreign key in mysql?
How you can create a trigger in mysql?
What is InnoDB?
How many columns can a table have?
What is default password for mysql?
What is the difference between truncate and delete?
What language is used in mysql?
How to return query output in html format?
Is sql and mysql same?