Final answer:
The states of a transaction in an RDBMS include Active, Partially Committed, and Committed. The correct answer to the question is 'Passive', as it is not a recognized state of an RDBMS transaction. The correct answer is option (b)
Step-by-step explanation:
The question pertains to the states of a transaction within a Relational Database Management System (RDBMS). In an RDBMS, a transaction is a unit of work that is treated in a coherent and reliable way independent of other transactions.
Transaction States
There are several states through which a transaction can pass:
- Active: This is the initial state of a transaction. In this state, the transaction is being executed.
- Partially Committed: After the final operation has been executed, but before the data has been committed to the database, the transaction is in a partially committed state.
- Committed: Once all of a transaction's data has been saved to the database and it can no longer be rolled back, the transaction is in the committed state.
The answer to the student's question is Passive, as it is not considered a standard state of a transaction within the context of RDBMS.