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

What is concurrency control?

497


What is a degree of relation?

568


What is dbms used for?

535


What you mean by Object Relational DBMS?

542


Do I need ccp4?

553






What are functions in database?

518


What is procedure in dbms?

483


What is a relation schema?

479


Can you explain the 'between' clause?

543


Mention the differences between trigger and stored procedures

519


How do I create a database?

495


1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

1819


Explain atomicity and aggregation?

574


Why is normalisation used?

492


What is database optimization?

513