Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is ACID?

Answers were Sorted based on User's Feedback



What is ACID?..

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

What is ACID?..

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

Post New Answer

More MySQL Interview Questions

What's the difference between mysql and sql server?

0 Answers  


how many ways we can get the current date in mysql?

2 Answers  


Is primary key auto increment?

0 Answers  


What are the mysql database files stored in system ?

0 Answers  


How to write optimized query in mysql?

0 Answers  






What is insert query in mysql?

0 Answers  


What is mysql in dbms?

0 Answers  


How set mysql root password?

0 Answers  


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

0 Answers  


How can you filter the duplicate data while retrieving records from the table?

0 Answers  


How can you export the table as an xml file in mysql?

0 Answers  


What is database url for mysql?

0 Answers  






Categories