ACID Properties in DBMS

Database Interview Questions Database DBMS

ACID Properties in DBMS

Atomicity: Atomicity means all it's operations are execute it entirely or do not execute it at all.
There cannot be partial execution.

Consistency: The database must remain in a consistent state after execution of any transaction.Once the transaction is executed, it should move from one consistent state to another.

Isolation: In a database system where more than one transactions are being simultaneously executed. Transaction should be executed in isolation from other transactions (no Locks). During concurrent transaction should not affect the existence of any other transaction.

Durability: After successful completion of a transaction, the changes in the database should persist. Even in the case of system failures.

Top Articles

1- How to get total number of records of table in mysql

2- How to Sort an array of associative arrays by value of given key in php

3- Destructuring assignment in JavaScript

4- Tag Template literals (Strings) in JavaScript

5- String Concatenation in JavaScript

6- How to play multiple video in loop using HTML5 and JavaScript

7- Difference between null and undefined in JavaScript

8- localStorage, sessionStorage and cookies in JavaScript?

9- find the nth highest salary in mysql without limit

10- How to find greater than average salary records in MySQL

11- how to find duplicate records in MySQL query

12- How to use second index forcefully in MySQL

13- How to get total number of rows in MySQL table with and without count

14- Difference between where and having clauses

15- What is the difference between CHAR and VARCHAR ?

16- How to copy structure and data from one table to another table in MySQL

17- How to delete duplicate records in MySQL

18- Difference between DELETE, TRUNCATE and DROP commands in SQL

19- Difference between Union, Union all, INTERSECT and MINUS

20- ACID Properties in DBMS