ITPEC IP April 2020 Question 29
ITPEC IP April 2020 — Question 29 of 100
The new user should view the record only after the updating transaction completes. Concurrency control can lock or isolate the record so another transaction does not observe an incomplete intermediate state, thereby preserving consistency.
Answer (c)
Why not others:
- interrupting or canceling a valid update merely to serve a reader is inappropriate
- reading during the update may expose partially changed or uncommitted data
Key rule: Transaction isolation prevents concurrent users from seeing inconsistent intermediate states; committed results become safely visible after completion.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.