adplus-dvertising

Welcome to the Monitoring and Auditing MCQs Page

Dive deep into the fascinating world of Monitoring and Auditing with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Monitoring and Auditing, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Monitoring and Auditing, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

frame-decoration

Check out the MCQs below to embark on an enriching journey through Monitoring and Auditing. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Monitoring and Auditing. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Monitoring and Auditing MCQs | Page 7 of 10

Explore more Topics under SQL Server

Q61.
Which of the following is a change tracking function?

a.

WITH CHANGE_TRACK_CONTEXT

b.

CHANGE_TRACKING_MAX_VALID_VERSION()

c.

CHANGE_TRACKING_CURRENT_VERSION

d.

All of the mentioned

Discuss
Answer: (c).CHANGE_TRACKING_CURRENT_VERSION
Q62.
Point out the correct statement.

a.

A good example of one-way synchronization application is an occasionally connected application

b.

Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications

c.

After change tracking is configured for a table, any DDL statement that affects rows in the table will cause change tracking

d.

None of the mentioned

Discuss
Answer: (b).Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications
Q63.
Which of the following is the biggest disadvantage of change tracking?

a.

Schema changes are required in the server database

b.

Triggers are fired for each change that has been made to a row

c.

Logic for maintaining the correct row versions and deletions is easy

d.

All of the mentioned

Discuss
Answer: (b).Triggers are fired for each change that has been made to a row
Q64.
Which of the following query selects incremental inserts from the Sales.Customer table at the server?

a.

IF @sync_initialized == 0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END

b.

IF @sync_initialized = 0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END

c.

IF @sync_initialized =0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE_OPERATION = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END

d.

None of the mentioned

Discuss
Answer: (c).IF @sync_initialized =0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE_OPERATION = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END
Q65.
Point out the wrong statement.

a.

Change tracking is used for one way synchronization applications only

b.

Applications that have to synchronize data with an instance of the SQL Server Database Engine must be able to query for changes

c.

Two-way synchronization applications can also be built that use change tracking

d.

The two-way synchronization applications must be able to detect conflicts

Discuss
Answer: (a).Change tracking is used for one way synchronization applications only
Q66.
Which of the following code snippet returns a version integer that is associated with the last committed transaction that was tracked by change tracking?

a.

SELECT @sync_new_received_anchor = change_tracking_cur_version()

b.

SELECT @sync_new_received_anchor = change_tracking_current_ver()

c.

SELECT @sync_new_received_anchor = change_tracking_current_version()

d.

SELECT @sync_new_received_anchor = change_track_current_version()

Discuss
Answer: (c).SELECT @sync_new_received_anchor = change_tracking_current_version()
Q67.
Which of the following is a valid syntax for WITH CHANGE_TRACKING_CONTEXT?

a.

WITH CHANGE_TRACKING_CONTEXT (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount

b.

WITH CHANGE_TRACKI_CONTEXT (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount

c.

WITH CHANGE_TRACKING_CON (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount

d.

All of the mentioned

Discuss
Answer: (a).WITH CHANGE_TRACKING_CONTEXT (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount
Q68.
_____________ obtains tracking information for all changes to a table that have occurred since a specific version.

a.

CHANGETABLE_CONTEXT

b.

CHANGETABLE

c.

CHANGE_TRACKING_IS_COLUMN_IN_MASK

d.

All of the mentioned

Discuss
Answer: (b).CHANGETABLE
Q69.
Which of the following is a 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

Discuss
Answer: (a).sys.change_tracking_tables
Q70.
Which of the following feature distinguishes change data capture from change tracking?

a.

Historical data

b.

DML

c.

DML type

d.

Whether a column was changed

Discuss
Answer: (a).Historical data
Page 7 of 10

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...