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 indexing in database with example?
What is the most used database?
What is cold backup, hot backup, warm backup recovery?
What are notification services?
How many types of database language exist?
What is the meaning of flat file database?
Explain the concepts of a primary key and foreign key.
What is data abstraction in dbms?
Why do we need database?
What is limit in dbms?
How many types of relationship exist in database designing?
What is a functional dependency in the dbms?
What is dba in dbms?
What do you understand by intension and extension?
Explain the term entity in dbms?