Which of the following is catalog view used for change tracking ? Options: A . &nbspsys.change_tracking_tables B . &nbspsys.change_tracking_views C . &nbspsys.change_tracking_columns D . &nbspNone of the mentioned

Which of the following is catalog view used for change tracking ?

Question

Which of the following is catalog view used for change tracking ?

Options:

A . sys.change_tracking_tables

B . sys.change_tracking_views

C . sys.change_tracking_columns

D . None of the mentioned

Answer: Option A

sys.change_tracking_tables returns one row for each database in the instance of SQL Server that has change tracking enabled.

Was this answer helpful ?

Next Question

Question 1. Which of the following tool is used for purpose of data auditing for SQL Server only? ....

Question 2. Which of the following catalog view is used for SQL Server Extended Events ? ....

Question 3. Point out the wrong statement : ....

Question 4. Which of the following stored procedure will stop the trace ? ....

Question 5. Point out the wrong statement : ....

Question 6. Which of the following is one of the most crucial performance counters for monitoring ? ....

Question 7. Which of the following mode allows for the collection and uploading of data to occur on demand ? ....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0