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

This section includes 4 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_RETURNS_THE_AVERAGE_LATENCY_FOR_THE_MOST_RECENT_SESSIONS_??$

A. SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0
B. SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0
C. SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0
D. SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
Answer» C. SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0
Discussion
2.

___________gives_DBAs_an_option_to_shut_down_the_server_in_case_of_an_audit_log_failure.$

A. Shut down server on partial failure
B. Shut down server on audit log failure
C. Shut down server on complete failure
D. None of the mentioned
Answer» B. Shut down server on audit log failure
Discussion
3.

The commit time of each transaction with an associated entry in a database change table is available in the table __________

A. cdc.log_time_mapping
B. cdc.lsn_time_mapping
C. cdc.lsn_time_audit
D. All of the mentioned
Answer» C. cdc.lsn_time_audit
Discussion
4.

Which of the following error is returned for a query for all changes when a parameter that is used to define the query interval is not valid ?

A. An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_partial_changes_
B. An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_
C. An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_net_changes_
D. None of the mentioned
Answer» C. An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_net_changes_
Discussion