MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 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 | |
| 2. |
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 |
| Answer» D. sp_stop_status | |
| 3. |
Which of the following is an event class ? |
| A. | SQL:BatchCompleted |
| B. | Audit Password |
| C. | Lock:Blocked |
| D. | All of the mentioned |
| Answer» B. Audit Password | |
| 4. |
Which of the following is 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 |
| Answer» E. | |