DistillPrep
Python
GenAI
GenAI Frameworks
NLP
Deep Learning
Machine Learning
ML Libraries
Statistics
SQL
MLOps
Cloud
System Design
Blog
Learn
Practice
Test
Live Engine
Select Topic
SQL Fundamentals
(15)
Filtering And Conditions
(15)
Joins And Set Operations
(15)
Aggregation And Groupby
(15)
Window Functions
(15)
Subqueries And Ctes
(15)
String And Date Functions
(15)
Indexing
(15)
Query Optimization
(15)
Transactions And Acid
(15)
Database Design And Normalization
(15)
Nosql Vs SQL
(15)
SQL For Data Science
(15)
easy
Transactions And Acid
A bank runs this operation to transfer $100 from Account A to Account B. What ACID property ensures that either BOTH the debit and credit succeed, or NEITHER persists?
A
Consistency — the sum of all balances remains constant after the transaction
B
Atomicity — the transaction is an indivisible unit; all operations succeed together or all are rolled back
C
Isolation — other transactions cannot see intermediate states
D
Durability — committed data survives system crashes
Previous
Back
Next