The implicit beginning of a transaction is when _____.
A) a database is started
B) a table is accessed for the first time
C) the first SQL statement is encountered
D) the COMMIT command is issued

Question

Quizplus · Accepted Answer

The implicit beginning of a transaction occurs when the first SQL statement is encountered. This means that any subsequent actions performed in that session will be treated as part of the same transaction until a COMMIT or ROLLBACK command is issued. Starting the database or accessing a table for the first time does not necessarily begin a transaction, and issuing the COMMIT command explicitly marks the end of a transaction rather than its beginning.

The Implicit Beginning of a Transaction Is When _____