Question

Point out the wrong statement.

(a) It is the responsibility of the Transact-SQL programmer to issue COMMIT TRANSACTION only at a point when all data referenced by the transaction is logically correct

(b) The Database Engine increments the transaction count within a statement only when the transaction count is 1 at the start of the statement

(c) You cannot roll back a transaction after a COMMIT TRANSACTION statement is issued

(d) COMMIT transaction requires membership in the public role

The question was asked in an interview for internship.

This is a very interesting question from Transaction in chapter Performance Tuning and Optimization of SQL Server

Answer 1

Right option is (b) The Database Engine increments the transaction count within a statement only when the transaction count is 1 at the start of the statement

The explanation: The Database Engine increments the transaction count within a statement only when the transaction count is 1 at the start of the statement.