WHICH_OF_THE_FOLLOWING_QUERY_DETERMINE_SESSIONS_THAT_HAD_AN_EMPTY_SCAN_??$

Question

TuteeHUB · Accepted Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0

TuteeHUB · Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count  0

TuteeHUB · Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0

TuteeHUB · Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0

1.	WHICH_OF_THE_FOLLOWING_QUERY_DETERMINE_SESSIONS_THAT_HAD_AN_EMPTY_SCAN_??$
A.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count <> 0
B.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0
C.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0
D.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0
Answer» B. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0

Discussion