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!

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

CSS

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

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...