SQL Server MCQs with answers Page - 1

Here, you will find a collection of MCQ questions on SQL Server. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

Q. What is the Codename for SQL Server 2012?

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?

  • (A) sys.dm_exec_connections
  • (B) INFORMATION_SCHEMA.KEY_COLUMN_USAGE
  • (C) INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
  • (D) INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ