How do I solve WBJECA 2025 Computer questions?

Practice WBJECA 2025 Computer previous year questions with step-by-step solutions on Mathem Solvex. Each question includes a detailed explanation and video solution to help you master the concept quickly.

What is the difficulty level of WBJECA Computer questions?

WBJECA Computer questions range from moderate to advanced difficulty. Consistent practice with official previous year papers and topic-wise drills on Mathem Solvex is the most effective preparation strategy.

Are WBJECA previous year papers available for free?

Yes. Mathem Solvex provides free access to WBJECA previous year question papers and topic-wise PDFs. You can download them or attempt them as timed live mock tests directly on the platform.

WBJECA 2025 Computer PYQ — There is a possibility of a cascading rollback when:… | Mathem Solvex

A.
A transaction writes items that have been written only by a committed transaction.
B.
A transaction writes items that is previously written by an uncommitted transaction.
C.
A transaction reads an items that is previously written by an uncommitted transaction.
(Correct Answer)
D.
Both (B) and (C)

Correct Answer:

A transaction reads an items that is previously written by an uncommitted transaction.

Explanation

Correct Option: (C) A transaction reads an item that is previously written by an uncommitted transaction.

Explanation

A cascading rollback occurs in database management systems when the failure of one transaction leads to the necessity of rolling back other transactions that have become dependent on it.

The Mechanism: If Transaction $T_{1}$ writes a data item $X$ and does not commit, and Transaction $T_{2}$ reads that uncommitted value of $X$ , then $T_{2}$ is said to be dependent on $T_{1}$ . If $T_{1}$ subsequently fails and performs a rollback, $T_{2}$ must also be rolled back because it read "dirty" (uncommitted) data.
$D e p e n d e n cy : T_{2} reads X from T_{1} (uncommitted)$
$E f f ec t : Rollback (T_{1}) ⟹ Rollback (T_{2})$

WBJECA 2025 — Computer PYQ

Choose the correct answer:

Explanation

Explanation

Explanation

Explanation