Backend · Junior · Theory

What is a database transaction, and what does the acronym ACID stand for?

~4 min by voice

How to approach it

They're checking whether you understand a transaction as an indivisible unit of work and can explain each letter of ACID in your own words, with practical details: commands, rollback, the log, locks.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

transactions acid

Similar questions

Возьмём перевод между двумя счетами, которые лежат в одной базе: списать с одного, зачислить на другой. Как вы это реализуете, чтобы при параллельных операциях деньги не потерялись и баланс не ушёл в минус? Senior A method is annotated with @Transactional, but when an error occurs the data in the database isn't rolled back. What causes would you check? Mid-level During a sale, an online store sold more units of a product than it had in stock. The code first checks the stock level and then decrements it. Why did this happen, and how would you fix it? Mid-level How does the @Transactional annotation work in Spring? Junior What anomalies occur with concurrent transactions, and how do isolation levels protect against them? Give an example where Read Committed would let you down. Senior

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min