Database Systems Practice Test

What does a commit operation do in a database?

Marks updates as permanent but not necessarily written to disk Inserts a new transaction log entry without persisting changes Causes all the updates to be recorded on the disk Reverts updates since the last commit

Correct Answer:

Causes all the updates to be recorded on the disk

Explanation:

A commit finalizes a transaction and makes its changes durable. When you commit, the database records all the operations of that transaction in the persistent log and ensures those changes are written to durable storage. This guarantees that after a crash, the committed updates survive and are visible to other transactions. The idea is that a commit moves changes from being provisional to permanently stored on disk. The other options miss this durability aspect or describe rollback behavior, which is not what a commit does.

Access more questions from this quiz

Continue to Database Systems Practice Test for more practice questions and the full quiz experience.

Access More Questions