Advertisements
Advertisements
Question
What are the ACID properties?
Answer in Brief
Advertisements
Solution
- The acronym stands for Atomicity, Consistency, Isolation and Durability. Atomicity follows the thumb rule “All or Nothing” while updating the data in the database for the user performing the update operation.
- Consistency ensures that the changes in data value to be constant at any given instance. Isolation property is needed during concurrent action.
- Durability is defined as the system’s ability to recover all committed actions during the failure of storage or the system.
shaalaa.com
Is there an error in this question or solution?
APPEARS IN
RELATED QUESTIONS
What is meant by cell address?
State the significance of the following in DBMS :
(i) Forms
(ii) Reports
Write the steps to filter a table.
__________ is a collection of related data.
What is the acronym of DBMS?
What symbol is used for the SELECT statement?
What is the difference between the Select and Project commands?
The ______ diagram gives a logical structure of the database graphically?
Why is database testing important?
List any two types of storage devices in DBMS.
