SQL Server Questions and Answers – Introduction

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Introduction”.

1. When was the first version of Microsoft SQL Server released?
a) 1983
b) 1988
c) 1990
d) 1991
View Answer

Answer: b
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.

2. 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 Mentioned
View Answer

Answer: d
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.

3. Which of the SQL Server RTM included native support for managing XML data?
a) 7.0
b) 6.5
c) 8
d) 9
View Answer

Answer: d
Explanation: Support for XML is integrated into all the components from SQL Server 2005 RTM 9.

4. Codename for SQL Server 2012 is __________
a) Kilimanjaro
b) Katmai
c) Denali
d) Hekaton
View Answer

Answer: c
Explanation: Codenames for SQL Server 2005, 2008, 2008 R2, 2012, 2014 are Yukon, Katmai, Kilimanjaro, Denali and Hekaton respectively.

5. SQL Server 2005 has the following features?
a) Dynamic Management Views
c) Powerpivot
d) In-memory capability
View Answer

Answer: a
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.
Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

6. _________ 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 Studio
View Answer

Answer: d
Explanation: 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.

7. LocalDB was introduced in which of the following versions of SQL Server?
a) 2012
b) 2008
c) 2014
d) 2008 R2
View Answer

Answer: a
Explanation: LocalDB was introduced in SQL Server 2012 CTP3. It’s basically a new version of SQL Express, with same functionality, dedicated to developers.

8. _________ is free database software running free SQL Server technology.
a) SQL Server Express
b) SQL Server Workgroup
c) SQL Server Enterprise
d) SQL Server Web
View Answer

Answer: a
Explanation: SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine.

9. __________is the first true GUI-based database server.
a) SQL Server 7.0
b) SQL Server 6.5
c) SQL Server 2005
d) SQL Server 2008
View Answer

Answer: a
Explanation: SQL Server 7.0 provides a graphical user interface to interactively build a query and view the result for data source types.

10. Which was the first version of SQL Server to introduce in-memory capability?
a) SQL Server 2012
b) SQL Server 2014
c) SQL Server 2005
d) SQL Server 2008
View Answer

Answer: b
Explanation: SQL Server 2014 provides a new in-memory capability for tables that can fit entirely in memory (also known as Hekaton).

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.