When does a COMMIT command implicitly 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 computer loses power unexpectedly.

Question

​When does a COMMIT command implicitly 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 computer loses power unexpectedly.

Quizplus · Accepted Answer

A COMMIT command implicitly occurs when a user issues a Data Definition Language (DDL) command like CREATE or ALTER TABLE. DDL commands automatically commit any pending transactions in most relational database management systems.

​When Does a COMMIT Command Implicitly Occur

When Does a COMMIT Command Implicitly Occur