Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 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.

WHAT_DOES_COLLECTOR_TYPE_ID_STANDS_FOR_IN_THE_FOLLOWING_CODE_SNIPPET_??$

A.
B. uniqueidentifier
C. membership role
Answer» B. uniqueidentifier
Discussion
2.

Which of the following is syntax for sp_add_collector_type procedure ?

A. core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’
B. core.sp_add_collector_type [ @collector_type_uid = ].
C. core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’
D. none of the mentioned
Answer» D. none of the mentioned
Discussion
3.

Which of the following table is used in management data warehouse schema that is required for the Server Activity ?

A. snapshots.query_stat
B. snapshots.os_latch_stats
C. snapshots.active_sessions
D. all of the mentioned
Answer» C. snapshots.active_sessions
Discussion
4.

____________ stores information about how the management data warehouse reports should group and aggregate performance counters.

A. core.snapshots_internal
B. core.supported_collector_types_internal
C. core.wait_categories
D. core.performance_counter_report_group_items
Answer» E.
Discussion
5.

Which of the following is best Practice and Caveat for Management Data Warehouse ?

A. Use a centralized server for the MDW database
B. The XML parameters for a single T-SQL collection item can have multiple <Query> elements
C. Use a distributed server for the MDW database
D. All of the mentioned
Answer» B. The XML parameters for a single T-SQL collection item can have multiple <Query> elements
Discussion
6.

Which of the following scenario favours cached mode ?

A. Continuous collection of data
B. Less frequent uploads
C. Data collection and uploading of jobs on different schedules
D. All of the mentioned
Answer» E.
Discussion
7.

Which of the following mode allows for the collection and uploading of data to occur on demand ?

A. Non-cached mode
B. Cached mode
C. Mixed mode
D. All of the mentioned
Answer» B. Cached mode
Discussion
8.

_________ introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting.

A. SQL Server 2005
B. SQL Server 2008
C. SQL Server 2012
D. SQL Server 2014
Answer» C. SQL Server 2012
Discussion