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
Compare non-clustered and clustered index
Define entity, entity type, and entity set.
Explain atomicity and aggregation?
What is n tier architecture in dbms?
What do you mean by entity type?
Can files be stored in a database?
What are the four components of a database system?
What is field in database give an example?
What are the steps in creating a database?
What are different type of normalization?
What are database data types?
Define database lock?
How to activate all indexes in firebird?
What are the disadvantages of file processing systems?
What is the best free database?