What are ACID properties?

Answer Posted / pallis

Atomicity
The entire sequence of actions must be either completed or aborted. The transaction cannot be partially successful.
Consistency
The transaction takes the resources from one consistent state to another.
Isolation
A transaction's effect is not visible to other transactions until the transaction is committed.
Durability
Changes made by the committed transaction are permanent and must survive system failure.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain by listing some of dbms major advantages.

540


Define weak entity set.

724


What is database example?

539


What are the restrictions applicable while creating views?

584


What is system r? How many of its two major subsystems?

610






What database should I learn first?

612


Can group by and ordered by used in a single query?

625


What are the advantages of database management system?

536


What are the functions of rdbms?

578


What is a database in a website?

598


What is a Built_in subprogram ?

3551


What is dba stand for?

559


How do queries work in a database?

575


What are different types of joins in sql?

601


how to generate an auto incremental number in a ssis package?

597