Patty begins entering an order into her DBMS using SQL, but soon discovers she cannot complete the order entry process owing to missing data. What should she do to follow best practices related to transactions?
A) turn on the Autocommit feature
B) execute the ROLLBACK command
C) leave the order in a partially entered state
D) execute the COMMIT command

Question

Quizplus · Accepted Answer

Executing the ROLLBACK command is the best practice in this situation because it undoes any changes made during the transaction, ensuring the database remains consistent and no partial or incomplete data is saved.

Patty Begins Entering an Order into Her DBMS Using SQL