Q1. What does ACID mean in the context of transactions?
ACID describes the guarantees of a transaction, a unit of work that either completes fully or not at all. - Atomicity: all statements commit or all roll back. Implemented...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (8 available).
Active:
Tag: transactions ×
Q2. How does the saga pattern handle distributed transactions?
A saga replaces a single ACID transaction across services with a sequence of local transactions, each publishing an event or invoking the next step. If a step fails, prev...
Q3. What causes a database deadlock and how do you prevent one?
A database deadlock is a cycle where two or more transactions each hold a lock the other needs, so neither can proceed. ```text T1: UPDATE a; UPDATE b; T2: UPDATE b; UPDA...
Q4. What are pipelining and transactions in Redis?
Pipelining sends many commands in one network round trip without waiting for each reply, dramatically improving throughput for batch workloads since cost is dominated by ...
Q5. Explain two-phase commit and its drawbacks.
Two-phase commit, 2PC, is an atomic commit protocol for transactions spanning multiple databases or resource managers. Phase one, prepare: the coordinator asks every part...
Q6. How does Kafka provide exactly-once semantics?
Kafka combines two features: - Idempotent producer: each producer gets a producer id and sequence numbers. The broker deduplicates retries within a session, so a network ...
Q7. What does "locking" refer to?
A mechanism to prevent concurrent transactions from interfering with each other. Locks can be **shared** (read locks, multiple allowed) or **exclusive** (write locks, onl...
Q8. What if autocommit is enabled?
Every individual statement is automatically committed. In MySQL, autocommit is ON by default. Turn it off for multi-statement transactions: ```sql SET autocommit = 0; -- ...