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
What is difference between mysql and mysql server?
What is slow query log in mysql?
Why do we use pragma autonomous transaction?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
How do I show columns in mysql?
How to present a past time in hours, minutes and seconds?
Can't connect mysql server on localhost?
What is longblob in mysql?
Where is mysql data stored linux?
How can you make a database as your current database?
How do I download a mysql community server?
How do you know the version of your mysql server?
Can you tell which of the following where clauses is faster?
Why phpmyadmin is used for mysql?
How does select query work?