131k views
2 votes
An explicit commit is issued when the user executes a COMMIT; command.​

a. True
b. False

User Uminder
by
6.9k points

1 Answer

1 vote

Final answer:

An explicit commit is indeed initiated when a user executes a COMMIT; command in a database transaction, making all changes permanent and releasing resources used during the transaction.

Step-by-step explanation:

The statement that an explicit commit is issued when the user executes a COMMIT; command is true. In database management systems, explicit commits are used to permanently save all changes made by the current transaction to the database. When the COMMIT command is issued, it signifies that all modifications made during the transaction are correct and can be made permanent. This action also signals to the database management system that it can free up any resources that were used during the transaction and make the changes visible to other transactions.

User Sammarcow
by
7.1k points