Advertisements
Advertisements
Question
What are the ACID properties?
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.
APPEARS IN
RELATED QUESTIONS
What is meant by cell address?
State the significance of the following in DBMS :
(i) Forms
(ii) Reports
The ______ diagram gives a logical structure of the database graphically?
How is a top to bottom relationship among the items in a database established?
A database ______ certain details about how data is actually stored and maintained.
What do you call the database catalogue where DBMS stores database schema along with various constraints?
The underlying component or set of programs used by DBMS to create the database and handle various queries for data retrieval and manipulation is known as ______.
Differentiate between Database state and database schema.
Give the shortcut that is used to select a row in Excel.
List any two types of storage devices in DBMS.
