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 :
A. SELECT
B. DDL
C. DML
D. All of the mentioned
Answer:A
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 :
A. SELECT B. DDL C. DML D. All of the mentioned
Explanation:If there is an error occuring within these statements individually, SQL Server will roll back the complete statement. 9. ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement for ___________ transactions.