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) none of the above.

Question

Quizplus · Accepted Answer

Explicit commands to manage transactions are needed when multiple SQL commands must be run as part of a transaction. If a transaction consists of just one SQL command, autocommit will handle it automatically. If autocommit is set to off, all SQL commands will be part of a single transaction unless explicit transaction commands are used to separate them. Therefore, option B is the best choice.

Explicit Commands to Manage Transactions Are Needed When