If TRANCOUNT is 1 ________ makes all data modifications performed since the start of the transaction a permanent part of the database.

Explore topic-wise MCQs in SQL Server.

This section includes 1 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.

1.	If TRANCOUNT is 1 ________ makes all data modifications performed since the start of the transaction a permanent part of the database.
A.	COMMIT TRANSACTION
B.	SAVE TRANSACTION
C.	ROLLBACK TRANSACTION
D.	None of the mentioned
Answer» B. SAVE TRANSACTION

Discussion