Home / Programming Questions / SQL Server MCQs / Page 1

SQL Server MCQs with answers Page - 1

Dear candidates you will find MCQ questions of SQL Server here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

Q. What is SQL Server?

(A) SQL Server is a relational database management system
(B) SQL Server is a software whose main purpose is to store and retrieve data
(C) SQL Server is a highly secure server and does not allow any database file manipulation during execution
(D) All of the mentioned

Q. When was the first version of Microsoft SQL Server released?

(A) 1991
(B) 1990
(C) 1988
(D) 1983

Q. Which of the following is a free database software running free SQL Server technology?

(A) SQL Server Web
(B) SQL Server Enterprise
(C) SQL Server Workgroup
(D) SQL Server Express

Q. Which of the following companies originally worked together to create and market the first version of SQL Server?

(A) Sybase
(B) Ashton-Tate
(C) Microsoft
(D) All of the Mentioned

Q. What is the Codename for SQL Server 2012?

(A) Katmai
(B) Denali
(C) Hekaton
(D) Kilimanjaro

Q. Which was the first version of SQL Server to introduce in-memory capability?

(A) SQL Server 2005
(B) SQL Server 2008
(C) SQL Server 2012
(D) SQL Server 2014

Q. Which of the following data type is not present in SQL Server?

(A) geography
(B) hierarchyid
(C) boolean
(D) bit

Q. Which database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators?

(A) temp
(B) model
(C) msdb
(D) master


Forgot username? click here

Forgot password? Click here

Don't have account? Register here.