Question

The ____________________ command will reverse all DML operators performed since the last COMMIT was performed.​

a. ROLLBACK
b. COMMIT
c. REVERT
d. UNDO

Answer 1

The ROLLBACK command undoes all DML operations since the last COMMIT in a database. This maintains data integrity and helps recover from errors during transactions.

Step-by-step explanation:

The command that will reverse all DML operations performed since the last COMMIT was performed is ROLLBACK. When a ROLLBACK command is issued in a database management system, it undoes all the changes made to the database in the current transaction, if the transaction has not yet been made permanent with a COMMIT. This is particularly useful during transaction management for maintaining data integrity and for recovery purposes when errors occur during the processing of transactions.