gs gs116 Monitoring and Auditing - SQL Server Profiling - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Monitoring and Auditing. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following is the benefit of SQL Server Profiler?
Capturing the series of Transact-SQL statements that lead to a problem
Finding and diagnosing slow-running queries
Correlating performance counters to diagnose problems
All of the mentioned
Question 2: Point out the correct statement.
SQL Server Profiler also supports auditing the actions performed on instances of SQL Server
A profiler class is a type of event that can be traced
A profile category defines the way events are grouped within SQL Server Profiler
None of the mentioned
Question 3: Which of the following is an event class?
SQL:BatchCompleted
Audit Password
Lock:Blocked
All of the mentioned
Question 4: Which of the following stored procedure will stop the trace?
sp_trace_create.
sp_trace_setfilter
sp_trace_setstatus
sp_stop_status
Question 5: Point out the wrong statement.
If a filter is set, all events of the selected event classes are returned in the trace output
A trace captures data based on selected event classes, data columns, and filters. For example, you can create a trace to monitor exception errors
A data column is an attribute of event classes captured in the trace
All of the mentioned
Question 6: Which of the following is syntax for sp_trace_setevent?
sp_trace_setevent [ @traceid = ] trace_id , [ @eventid = ] event_id , [ @columnid = ] column_id , [ @on = ] on sp_trace_setevent [ @traceid = ] trace_id OUTPUT , [ @options = ] option_value , [ @tracefile = ] 'trace_file' [ , [ @maxfilesize = ] max_file_size ] [ , [ @stoptime = ] 'stop_time' ] [ , [ @filecount = ] 'max_rollover_files' ] sp_trace_setevent [ @traceid = ] trace_id , [ @status = ] status
None of the mentioned
Question 7: Which of the following argument has option value 2 in sp_trace_create procedure?
TRACE_PRODUCE_BLACKBOX
SHUTDOWN_ON_ERROR
TRACE_FILE_ROLLOVER
All of the mentioned
Question 8: Which of the following events and their columns are contained in the trace?
Attention
Batch starting
Exception
All of the mentioned
Question 9: TRACE_PRODUCE_BLACKBOX file can be saved in the following location?
N’%SQLDIR%\MSSQL\DATA\blackbox.trc
N’%SQLDIR%\MSSQL\DATA\black.trc
N’%SQLDIR%\MSSQL\DATA\box.trc
None of the mentioned
Question 10: Which of the following event has event number 15 in the trace?
DTCTransaction
ErrorLog
SQL:BatchStarting
Lock:Cancel
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
