Answers were Sorted based on User's Feedback
Answer / gurmeet shah
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
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's the difference between mysql and sql server?
how many ways we can get the current date in mysql?
Is primary key auto increment?
What are the mysql database files stored in system ?
How to write optimized query in mysql?
What is insert query in mysql?
What is mysql in dbms?
How set mysql root password?
What, if a table has one column defined as TIMESTAMP?
How can you filter the duplicate data while retrieving records from the table?
How can you export the table as an xml file in mysql?
What is database url for mysql?