After a transaction begins to execute, it enters one of several states, the first of which is the ..........state, in which read or write activities occur .

Question

A. Committed state B. Active state
C. Aborted state D. Log state

Answer 1

The correct answer is B. Active state.

In the context of transactions, the active state is where the transaction is executing and performing read or write operations. The other states (committed, aborted, and log) pertain to different phases of the transaction lifecycle.