Question

question 26
if a(n) ____ is issued before the termination of a transaction, the dbms will restore the database only for that particular transaction, rather than for all transactions, in order to maintain the durability of the previous transactions.
○ rollback
○ commit
○ execute
○ log

Explanation:

In database transactions, a rollback operation is used to undo the changes of a transaction that did not complete successfully. If a rollback is issued before a transaction terminates, the DBMS restores the database to its state before the transaction, maintaining the durability of previous transactions. Commit makes changes permanent, Execute is for running statements, and Log is for recording transactions, not for restoring the database in this context.

Answer:

A. Rollback