This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “System Databases”. 1. Which of the following is not a system database? a) Northwind b) Master c) Tempdb d) All of the mentioned 2. Point out the correct statement. a) By default, tempdb auto grows as needed while SQL Server is running … Read more
This set of tricky SQL Server questions and answers focuses on “Specifications – 2”. 1. What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine? a) 811 Mb b) 711 Mb c) 611 Mb d) 511 Mb 2. Point out the correct statement. a) SQL Server books online is part of Microsoft … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Specifications – 1”. 1. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine? a) 811 Mb b) 711 Mb c) 611 Mb d) 511 Mb 2. Point out the correct statement. a) SQL Server books online is part … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Analyzing Data With Excel”. 1. _____________ for Office is a lightweight set of tools for predictive analytics. a) SQL Server 2008 Data Mining Add-ins b) SQL Server 2012 Data Mining Add-ins c) SQL Server 2014 Data Mining Add-ins d) SQL Server 2012 … Read more
This set of SQL Server Assessment Questions and Answers focuses on “Reporting Services – 2”. 1. A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information. a) Main b) Detail c) Drillthrough d) All of the mentioned 2. Point out the correct … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Reporting Services – 1”. 1. Which of the following tool requires Reporting Services in SharePoint mode? a) Report Designer b) Power View c) Report Builder d) None of the mentioned 2. Point out the correct statement. a) The tools that you use … Read more
This set of Basic SQL Server Interview questions and answers focuses on “MDX – 2”. 1. __________ is the set of hierarchies from which data is retrieved for a single member. a) Slicer axis b) Query axes c) Dice axis d) All of the mentioned 2. Point out the correct statement. a) Only dropping the … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “MDX – 1”. 1. _______ lets you manage cube context from within an MDX script. a) CALCULATE b) CALC c) SCOPE CALC d) None of the mentioned 2. Point out the correct statement. a) Few MDX queries run within a specified cube … Read more
This set of SQL Server Problems focuses on “Analysis Services – 3”. 1. _______ is currency used to store transactions on which measures to be converted are based in SSAS. a) Local currency b) Pivot currency c) Global currency d) None of the mentioned 2. Point out the correct statement. a) The Type property of … Read more
This set of SQL Server Aptitude Test focuses on “Analysis Services – 2”. 1.In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension. a) Translation b) Dimension translation c) Dim translation d) None of the mentioned 2. Point out the correct statement. a) The collation … Read more
