Question 590
After validating two updates in an open transaction, which command persists them?
Explanation
Correct Answer
Correct for commit the pending changes: COMMIT makes pending transactional changes permanent.
Incorrect Answers
Not the right operation for commit the pending changes: BEGIN TRANSACTION starts an explicit transaction for a multi-statement unit of work.
Not the right operation for commit the pending changes: ROLLBACK abandons the uncommitted effects of a transaction.
Not the right operation for commit the pending changes: Autocommit mode controls whether eligible individual statements commit automatically.