Which of the following argument has option value 2 in sp_trace_create – McqOptions

MCQOPTIONS

1.	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
Answer» D. All of the mentioned

Discussion

No Comment Found

Related MCQs

TRACE_PRODUCE_BLACKBOX file can be saved in the following location?
Which of the following query returns the average latency for the most recent sessions?
Which of the following event has event number 15 in the trace?
Which of the following query determine sessions that had an empty scan?
Which of the following stored procedure will stop the trace?
Which of the following table is used in the management data warehouse schema that is required for the Server Activity?
_____________ obtains tracking information for all changes to a table that have occurred since a specific version.
Which of the following script enable a Table for all and Net Changes Queries?
Which of the following pair of views has one to many relationship?
Which of the following mode allows for the collection and uploading of data to occur on demand?