A database administrator executed multiple transactions and needs to finish the operations. Which of the following functions should the administrator use?

The correct answer is D. Commit. Commit finalizes all pending transaction operations and makes changes permanent in the database - it is the standard SQL command used to end a transaction and persist its effects. Rollback (C) is the opposite: it undoes all changes made during the transaction, reverting the datab

Database Fundamentals

Question

Options

ASave
BReturn
CRollback
DCommit

How the community answered

(18 responses)

A
6% (1)
D
94% (17)

Explanation

Commit finalizes all pending transaction operations and makes changes permanent in the database - it is the standard SQL command used to end a transaction and persist its effects. Rollback (C) is the opposite: it undoes all changes made during the transaction, reverting the database to its previous state, which is useful for error recovery but not for "finishing" operations successfully. Save (A) and Return (B) are not valid SQL transaction control commands - SAVEPOINT exists but only marks a point within a transaction, and RETURN belongs to procedural/function contexts, not transaction management.

Memory tip: Think of it like writing a document - COMMIT is hitting Save & Submit (permanent), while ROLLBACK is hitting Discard Changes (undo). If you want the work to count, you must COMMIT.

Topics

#Database Transactions#COMMIT operation#Transaction Control#DML operations

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice