Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

101.

_________ is a software application first launched with the Microsoft SQL Server 2005.(a) Enterprise Manager(b) Query Analyzer(c) Business Intelligence Development Studio(d) SQL Server Management StudioThis question was posed to me in an international level competition.My question is from Introduction topic in division Laying the Foundation of SQL Server

Answer» CORRECT option is (d) SQL Server MANAGEMENT STUDIO

For explanation I would say: SQL Server Management Studio (SSMS) is an INTEGRATED environment that combines the features of Enterprise Manager, Query ANALYZER, and Analysis Manager, included in previous releases of SQL Server, into a single environment.
Discussion
102.

SQL Server 2005 has the following features?(a) Dynamic Management Views(b) FILESTREAM(c) Powerpivot(d) In-memory capabilityThis question was addressed to me in an interview for internship.I want to ask this question from Introduction in division Laying the Foundation of SQL Server

Answer»

Correct option is (a) DYNAMIC Management Views

The explanation: SQL Server 2005 INTRODUCED DMVs (Dynamic Management Views), which are specialized views and functions that return server STATE INFORMATION. FILESTREAM, Powerpivot and in-memory capability were introduced in 2008,2008 R2 and 2014 respectively.
Discussion
103.

Codename for SQL Server 2012 is __________(a) Kilimanjaro(b) Katmai(c) Denali(d) HekatonThe question was asked during an online exam.Origin of the question is Introduction in division Laying the Foundation of SQL Server

Answer»

Correct option is (c) Denali

Easiest EXPLANATION: Codenames for SQL Server 2005, 2008, 2008 R2, 2012, 2014 are Yukon, Katmai, Kilimanjaro, Denali and HEKATON respectively.
Discussion
104.

Which of the SQL Server RTM included native support for managing XML data?(a) 7.0(b) 6.5(c) 8(d) 9This question was posed to me during an interview.I'm obligated to ask this question of Introduction topic in chapter Laying the Foundation of SQL Server

Answer»

Correct option is (d) 9

Easiest EXPLANATION: Support for XML is integrated into all the COMPONENTS from SQL SERVER 2005 RTM 9.
Discussion
105.

Which of the following companies originally worked together to create and market the first version of SQL Server?(a) Microsoft(b) Sybase(c) Ashton-Tate(d) All of the MentionedI got this question in an online quiz.My question comes from Introduction in portion Laying the Foundation of SQL Server

Answer»

Right CHOICE is (d) All of the Mentioned

Explanation: First version of SQL Server was DESIGNED for the OS/2 PLATFORM and was DEVELOPED jointly by Microsoft and Sybase along with Ashton-Tate.
Discussion
106.

When was the first version of Microsoft SQL Server released?(a) 1983(b) 1988(c) 1990(d) 1991I got this question in final exam.I'm obligated to ask this question of Introduction topic in portion Laying the Foundation of SQL Server

Answer»

Right ANSWER is (b) 1988

The best explanation: Microsoft released its FIRST version of SQL Server in the year of 1988. This version was developed jointly by Microsoft and Sybase for the OS/2 platform.
Discussion