Explicit commands to manage transactions are needed when:
A) a transaction consists of just one SQL command.
B) multiple SQL commands must be run as part of a transaction.
C) autocommit is set to off.
D) DDL statements are prohibited.

Question

Quizplus · Accepted Answer

Explicit commands to manage transactions are needed when multiple SQL commands must be run as part of a transaction. This ensures that all the commands are treated as a single transaction and either all of them will be committed or rolled back if there are any errors.

Option A is incorrect because if a transaction consists of just one SQL command, there is no need to manage the transaction explicitly.

Option C is partially correct as autocommit being set to off may need explicit transaction management, but it is not the only condition where explicit commands are required.

Option D is not correct because the prohibition of DDL statements does not necessarily mean that explicit commands are needed for transaction management.

Explicit Commands to Manage Transactions Are Needed When