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 ?
A. COMMIT TRANSACTION accepts a user-defined transaction name
B. COMMIT WORK accepts a user-defined transaction name
C. COMMIT TRANSACTION accepts a user-defined function
D. COMMIT WORK accepts a user-defined stored procedure
Answer:A
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 ?
A. COMMIT TRANSACTION accepts a user-defined transaction name B. COMMIT WORK accepts a user-defined transaction name C. COMMIT TRANSACTION accepts a user-defined function D. COMMIT WORK accepts a user-defined stored procedure
Explanation:COMMIT syntax, with or without specifying the optional keyword WORK, is compatible with SQL-92. 8. Implicit transactions are maintained by SQL Server for :