[Solved]Question 1 2 Points Save Transaction Save Point Used Partially Rollback Changes Within Tra Q37088058

Question 1 (2 points) A SAVE TRANSACTION or save point can be used to just partially rollback changes within a transaction. True False Question 2 (2 points) What happens when a ROLLBACK is issued? Only changes since the most recent COMMIT are undone. All previous changes on the connection are undone The @@TRANCOUNT is decremented by 1 An error occurs if @@TRANCOUNT O Question 3 (2 points) A transaction always exhibits “all or nothing” behavior in Transact SQL True False Show transcribed image text Question 1 (2 points) A SAVE TRANSACTION or save point can be used to just partially rollback changes within a transaction. True False Question 2 (2 points) What happens when a ROLLBACK is issued? Only changes since the most recent COMMIT are undone. All previous changes on the connection are undone The @@TRANCOUNT is decremented by 1 An error occurs if @@TRANCOUNT O Question 3 (2 points) A transaction always exhibits “all or nothing” behavior in Transact SQL True False

Expert Answer

---

Answer to Question 1 (2 points) A SAVE TRANSACTION or save point can be used to just partially rollback changes within a transacti… . . .