Question

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

This question was posed to me in an interview for job.

Enquiry is from SQL Audit topic in division Monitoring and Auditing of SQL Server

Answer 1

Right option is (b) An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_

The best I can explain: Sometimes even the error message arises when the row filter option is invalid.