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
If you need to refresh a website page every time a record is updated in database, how would you do it?
Why rdbms is not suitable for big data?
What is dbms with example?
What is cardinality in db?
What is data types in database?
What is rdbms and also explain its components?
What is the main purpose of a database?
what is the difference between two and three-tier architectures?
What is Data Redundancy and Consistency ?
How to drop all foreign keys in database?
What do you mean by Checkbox ?
what is the difference between filters and conditions?
What are the 5 databases?
What is denormalization and why would someone consider doing so?
How do you create a report in a database?
