When does a COMMIT command explicitly occur?
A) When the user executes COMMIT;.
B) When the user issues a DDL command such as CREATE or ALTER TABLE.
C) When the user executes ROLLBACK;.
D) When the user exists the system.

Question

When does a COMMIT command explicitly occur?​
A) ​When the user executes COMMIT;.
B) ​When the user issues a DDL command such as CREATE or ALTER TABLE.
C) ​When the user executes ROLLBACK;.
D) ​When the user exists the system.

Quizplus · Accepted Answer

The COMMIT command explicitly occurs when the user executes COMMIT; which commits the current transaction and makes all changes permanent.

When Does a COMMIT Command Explicitly Occur?​

When Does a COMMIT Command Explicitly Occur?