This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Query Plan Reuse”. 1. The use of parameters, including parameter markers in _______ applications, can increase the reuse of execution plans. a) OLE DB b) ADO c) ODBC d) All of the mentioned 2. Point out the correct statement. a) JDBC use … Read more
This set of SQL Server Questions & Answers for entrance exams focuses on “Indexing Strategies – 2”. 1. Which of the following query is used to enable a disabled index using CREATE INDEX? a) CREATE INDEX IX_Employee_OrganizationLevel_OrganizationNode ON HumanResources.Employee (OrganizationLevel, OrganizationNode) WITH (DROP_EXIST = ON); b) CREATE INDEX IX_Employee_OrganizationLevel_OrganizationNode ON HumanResources.Employee (OrganizationLevel, OrganizationNode) WITH (DROP_EXISTING … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Indexing Strategies – 1”. 1. Setting the SORT_IN_TEMPDB option to ON can direct the SQL Server Database Engine to use ________ to store the intermediate sort results. a) tempdb b) master c) msdb d) model 2. Point out the correct statement. a) … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Query Execution Plan”. 1. Which of the following syntax is valid? a) SET SHOWPLAN_XML { ON | OFF } b) SET SHOWPLAN { ON | OFF } c) SET SHOW_XML { ON | OFF } d) None of the mentioned 2. Point … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Management Data Warehouse”. 1. _________ 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 2. Point out the correct statement. … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “SQL Audit”. 1. Which of the following error is returned for a query for all changes when a parameter that is used to define the query interval is not valid? a) An insufficient number of arguments were supplied for the procedure or … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Change Data Capture”. 1. Which of the following script will enable CDC on HumanResources.Shift table? a) USE AdventureWorks GO EXEC sys.sp_cdc_enable @source_schema = N’HumanResources’, @source_name = N’Shift’, @role_name = NULL GO b) USE AdventureWorks GO EXEC sys.sp_cdc_disable_table @source_schema = N’HumanResources’, @source_name = … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Change Tracking”. 1. Which of the following is a change tracking function? a) WITH CHANGE_TRACK_CONTEXT b) CHANGE_TRACKING_MAX_VALID_VERSION() c) CHANGE_TRACKING_CURRENT_VERSION d) All of the mentioned 2. Point out the correct statement. a) A good example of one-way synchronization application is an occasionally connected … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Extended Events”. 1. Which of the following is an extended event task? a) create an Extended Events session b) alter an Extended Events session c) find out what events are available in the registered packages d) all of the mentioned 2. Point … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Wait States”. 1. Which of the following requires VIEW SERVER STATE permission on the server? a) sys.dm_os_states b) sys.dm_os_wait_stats c) sys.dm_os_wait_states d) none of the mentioned 2. Point out the correct statement. a) 510: CXPACKET indicates parallelism b) SQL Server does not … Read more
