Which Of The Following Query Determine Sessions That Had An #736
Which of the following query determine sessions that had an empty scan?
This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 Monitoring and Auditing - Change Data Capture - Quiz No.1.
Which of the following query determine sessions that had an empty scan?
SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count <> 0
SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0
SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0
SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0
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