Explanation:You cannot roll back a transaction after a COMMIT TRANSACTION statement is issued because the data modifications have been made a permanent part of the database. 5. 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
Answer:A
Explanation:You cannot roll back a transaction after a COMMIT TRANSACTION statement is issued because the data modifications have been made a permanent part of the database. 5. 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
Explanation:The Database Engine increments the transaction count within a statement only when the transaction count is 1 at the start of the statement. 6. A ROLLBACK TRANSACTION statement specifying a savepoint_name releases any locks that are acquired beyond the savepoint, with the exception of:.