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 db context?
State three differences between Dbms and Rdbms?
Why is database important?
What do you understand by correlated subqueries in dbms?
What are the limitations of using a model?
What the default privileges which get assigned ?
Why do we need database normalization?
What is the importance of database in an organization?
Why is maintaining a database important?
What do you understand by sub-queries in sql?
Explain the terms ‘attribute’ and ‘relations’
how to generate an auto incremental number in a ssis package?
What are data modelling tools?
How to recreate the index on a firebird table?
What is database normalization? Explain types of it.