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 are the advantages of using them.
What is openedge abl in terms of taking the perspective of the developer?
Differentiate table scan from index scan.
Which two can be implemented as a centrally located logical architecture?
What are the five important software components of a database management system?
What is data modelling explain?
What is Data Redundancy and Consistency ?
what is the difference between filters and conditions?
Describe the purposes and advantages stored procedure?
How do you create a blank database?
What are the integrity rules in dbms?
What is the easiest database to learn?
What are types of dbms?
What is procedure in dbms?
Enlist the cursor types.