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:.
A. escalations
B. containment
C. contention
D. None of the mentioned
Answer:A
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:.
A. escalations B. containment C. contention D. None of the mentioned
Explanation:These locks are not released, and they are not converted back to their previous lock mode. 7. What is the fundamental difference between COMMIT and COMMIT WORK ?