If Trancount Is 1 Makes All Data Modifications Performed Since #810
If @@TRANCOUNT is 1 ________ makes all data modifications performed since the start of the transaction a permanent part of the database.
This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 Performance Tuning and Optimization - SQL Server Transaction - Quiz No.1.
If @@TRANCOUNT is 1 ________ makes all data modifications performed since the start of the transaction a permanent part of the database.
COMMIT TRANSACTION
SAVE TRANSACTION
ROLLBACK TRANSACTION
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes