Explanation:CHANGETABLE obtains latest change tracking information for a specified row. 9. Which of the following is catalog view used for change tracking ?
A. sys.change_tracking_tables
B. sys.change_tracking_views
C. sys.change_tracking_columns
D. None of the mentioned
Answer:A
Explanation:CHANGETABLE obtains latest change tracking information for a specified row. 9. Which of the following is catalog view used for change tracking ?
A. sys.change_tracking_tables B. sys.change_tracking_views C. sys.change_tracking_columns D. None of the mentioned
Explanation:sys.change_tracking_tables returns one row for each database in the instance of SQL Server that has change tracking enabled. 10. Which of the following feature distinguishes change data capture from change tracking ?