PracHub
QuestionsPremiumLearningGuidesInterview PrepNEWCoaches
|Home/Software Engineering Fundamentals/Bitkernel

Classify concurrency anomaly between two transactions

Last updated: Mar 29, 2026

Quick Overview

This question evaluates proficiency in database concurrency control and transaction isolation within the Software Engineering Fundamentals domain, focusing on identifying concurrency anomalies that affect data integrity and update correctness.

  • medium
  • Bitkernel
  • Software Engineering Fundamentals
  • Software Engineer

Classify concurrency anomaly between two transactions

Company: Bitkernel

Role: Software Engineer

Category: Software Engineering Fundamentals

Difficulty: medium

Interview Round: Take-home Project

Two transactions `T1` and `T2` run concurrently and access the same data item `A`. Their operations (in order of time) are: 1. `T1` reads `A = 100`. 2. `T2` reads `A = 100`. 3. `T1` writes `A = A + 10` (so conceptually writes `110`). 4. `T2` writes `A = A - 10` (using its previously read value `100`, so writes `90`). Which description best characterizes the concurrency problem here? Options: - A. This operation cannot be repeatably read (non-repeatable read). - B. This operation has no problems. - C. This operation reads dirty data. - D. This operation loses modifications (lost update).

Quick Answer: This question evaluates proficiency in database concurrency control and transaction isolation within the Software Engineering Fundamentals domain, focusing on identifying concurrency anomalies that affect data integrity and update correctness.

Related Interview Questions

  • Evaluate C for-loop execution count - Bitkernel (medium)
  • Trace first pass of heap sort - Bitkernel (medium)
  • Find minimum two’s-complement value with three ones - Bitkernel (medium)
  • Analyze TCP three-way handshake states - Bitkernel (medium)
  • Identify incorrect statement about sockets - Bitkernel (medium)
Bitkernel logo
Bitkernel
Oct 24, 2025, 12:00 AM
Software Engineer
Take-home Project
Software Engineering Fundamentals
1
0

Two transactions T1 and T2 run concurrently and access the same data item A. Their operations (in order of time) are:

  1. T1 reads A = 100 .
  2. T2 reads A = 100 .
  3. T1 writes A = A + 10 (so conceptually writes 110 ).
  4. T2 writes A = A - 10 (using its previously read value 100 , so writes 90 ).

Which description best characterizes the concurrency problem here?

Options:

  • A. This operation cannot be repeatably read (non-repeatable read).
  • B. This operation has no problems.
  • C. This operation reads dirty data.
  • D. This operation loses modifications (lost update).

Solution

Show

Comments (0)

Sign in to leave a comment

Loading comments...

Browse More Questions

More Software Engineering Fundamentals•More Bitkernel•More Software Engineer•Bitkernel Software Engineer•Bitkernel Software Engineering Fundamentals•Software Engineer Software Engineering Fundamentals
PracHub

Master your tech interviews with 7,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.