What is ACID?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Is mysql better than oracle?

566


How to calculate the difference between two time values?

530


What are the advantages of mysql in comparison to oracle?

621


Can we write procedure in mysql?

577


How to analyze tables with 'mysqlcheck'?

782






What is the difference between truncate and delete?

671


How many rows can be inserted in mysql at a time?

594


Is mysql query case sensitive?

588


What is dbms in mysql?

598


What is dblink?

559


What is the difference between is null & is not null?

595


How many ways to get the current time?

596


How to add a new column to an existing table in mysql?

627


What is a transaction? Describe mysql transaction properties.

635


What are ddl statements in mysql?

618