MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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 | |
| 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 | |
| 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 | |
| 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_ | |