14 Questions Total

Transaction Management MCQs

Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.

Zero-leak answer engine • Rate-limited explanations

Practice in Timed Mode

Q1hard

An application requires that if a transaction is committed on a database in the USA, a synchronized backup database in Singapore must also have that data permanently stored before the transaction is acknowledged as "Success" to the user. This is an example of:

Discuss on Board

Q2hard

A transaction that cannot be completed successfully due to an internal error (like a deadlock or a hardware read failure) enters which state?

Discuss on Board

Q3easy

What is the result of the following psql session?

Discuss on Board

Q4hard

A developer writes a transaction that transfers 500 from Account A to Account B. If the developer accidentally writes code that adds 500 to Account B but only subtracts 400 from Account A, the database will finish in an invalid state. This is a violation of which property?

Discuss on Board

Q5medium

In the standard transaction state diagram, what is the critical difference between the Partially Committed state and the Committed state?

Discuss on Board

Q6hard

In a multi-user environment, User A is calculating the sum of all account balances. Simultaneously, User B transfers 100 from one account to another. User A's report must not see User B's partial work (e.g., seeing one account deducted but not yet the other credited). This is a requirement for:

Discuss on Board

Q7easy

What is the advantage of using Shadow Paging over Log-based recovery?

Discuss on Board

Q8hard

During a high-volume sale, a customer completes a purchase. The inventory is decremented, and the payment is processed. However, before the shipping label is generated, the database server loses power. Upon reboot, the system reverts the inventory and payment records to their state before the purchase began. Which ACID property is being enforced?

Discuss on Board

Q9medium

(Calculation/Comparison) Consider the "Log Sequence" below for an "Undo/Redo" recovery strategy. If a Checkpoint occurred at Time T, and the system crashed at T+1, which transactions must be Redone?

Discuss on Board

Q10medium

In most RDBMS (like MySQL/PostgreSQL), what is the default behavior of a single SQL statement (e.g., UPDATE x SET y=1;) not wrapped in an explicit transaction block?

Discuss on Board