Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 3 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

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
2.

If you do not want to use a gating role, explicitly set the @role_name parameter to :

A. 0
B. NULL
C. 1
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
3.

Which of the following disable database for Change Data Capture ?

A. EXEC sys.sp_cdc_ensable_db
B. EXEC sys.sp_disable_db
C. EXEC sys.sp_cdc_disable_db
D. All of the mentioned
Answer» B. EXEC sys.sp_disable_db
Discussion