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 4 of 10

Explore more Topics under SQL Server

Q31.
Which of the following is the benefit of SQL Server Profiler?

a.

Capturing the series of Transact-SQL statements that lead to a problem

b.

Finding and diagnosing slow-running queries

c.

Correlating performance counters to diagnose problems

d.

All of the mentioned

Discuss
Answer: (d).All of the mentioned
Q32.
Point out the correct statement.

a.

SQL Server Profiler also supports auditing the actions performed on instances of SQL Server

b.

A profiler class is a type of event that can be traced

c.

A profile category defines the way events are grouped within SQL Server Profiler

d.

None of the mentioned

Discuss
Answer: (a).SQL Server Profiler also supports auditing the actions performed on instances of SQL Server
Q33.
Which of the following is an event class?

a.

SQL:BatchCompleted

b.

Audit Password

c.

Lock:Blocked

d.

All of the mentioned

Discuss
Answer: (a).SQL:BatchCompleted
Q34.
Which of the following stored procedure will stop the trace?

a.

sp_trace_create.

b.

sp_trace_setfilter

c.

sp_trace_setstatus

d.

sp_stop_status

Discuss
Answer: (c).sp_trace_setstatus
Q35.
Point out the wrong statement.

a.

If a filter is set, all events of the selected event classes are returned in the trace output

b.

A trace captures data based on selected event classes, data columns, and filters. For example, you can create a trace to monitor exception errors

c.

A data column is an attribute of event classes captured in the trace

d.

All of the mentioned

Discuss
Answer: (a).If a filter is set, all events of the selected event classes are returned in the trace output
Q36.
Which of the following is syntax for sp_trace_setevent?

a.

sp_trace_setevent [ @traceid = ] trace_id
, [ @eventid = ] event_id
, [ @columnid = ] column_id
, [ @ON = ] ON

b.

sp_trace_setevent [ @traceid = ] trace_id OUTPUT
, [ @options = ] option_value
, [ @tracefile = ] 'trace_file'
[ , [ @maxfilesize = ] max_file_size ]
[ , [ @stoptime = ] 'stop_time' ]
[ , [ @filecount = ] 'max_rollover_files' ]

c.

sp_trace_setevent [ @traceid = ] trace_id ,
[ @STATUS = ] STATUS

d.

None of the mentioned

Discuss
Answer: (a).sp_trace_setevent [ @traceid = ] trace_id
, [ @eventid = ] event_id
, [ @columnid = ] column_id
, [ @ON = ] ON
Q37.
Which of the following argument has option value 2 in sp_trace_create procedure?

a.

TRACE_PRODUCE_BLACKBOX

b.

SHUTDOWN_ON_ERROR

c.

TRACE_FILE_ROLLOVER

d.

All of the mentioned

Discuss
Answer: (c).TRACE_FILE_ROLLOVER
Q38.
Which of the following events and their columns are contained in the trace?

a.

Attention

b.

Batch starting

c.

Exception

d.

All of the mentioned

Discuss
Answer: (d).All of the mentioned
Q39.
TRACE_PRODUCE_BLACKBOX file can be saved in the following location?

a.

N’%SQLDIR%\MSSQL\DATA\blackbox.trc

b.

N’%SQLDIR%\MSSQL\DATA\black.trc

c.

N’%SQLDIR%\MSSQL\DATA\box.trc

d.

None of the mentioned

Discuss
Answer: (a).N’%SQLDIR%\MSSQL\DATA\blackbox.trc
Q40.
Which of the following event has event number 15 in the trace?

a.

DTCTransaction

b.

ErrorLog

c.

SQL:BatchStarting

d.

Lock:Cancel

Discuss
Answer: (c).SQL:BatchStarting
Page 4 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!

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

JavaScript

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

Management Information Systems

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

Operating System

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

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

Discrete Mathematics

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

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...