Answer Posted / piyush sharma
ACID refers to the basic properties of a database
transaction: Atomicity, Consistency, Isolation, and
Durability.
All Oracle database, Oracle RDB and InnoDB transactions
comply with these properties. However, Oracle's Berkeley DB
database is not ACID-compliant.
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 ? | 64 Yes | 2 No |
Post New Answer View All Answers
What is concept of dbms?
How view is related to data independence?
What are the 5 major parts of a database system?
What do you mean by DBMS?
Is database a data structure?
What is a checkpoint in dbms and when does it occur?
What are the advantages of database?
What is db context?
Explain what are super servers?
Mention how deadlock can be resolved?
Mention the different languages present in dbms
What is system r? How many of its two major subsystems?
What restrictions can you apply when you are creating views?
Why is group-clause used?
What do you understand by e-r model?
