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 are the differences between drop a table and truncate a table?
Write a command with which mysql table can be repaired
How will you export tables as an xml file in mysql?
What does tinyint mean?
How do I get a list of table names in mysql?
suppose server is running Suddenly down . what can you do? but i want do not down the server?
What is the query to display top 20 rows?
What is the difference between SQL and SQL Server?
How to use count function in mysql?
Does mysql support sequence?
What is innodb_buffer_pool_size?
Is mysql written in c?