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

📊 SQL Server
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
💬 Discuss
✅ Correct Answer: (A) SQL Server is a relational database management system
📊 SQL Server
Q. When was the first version of Microsoft SQL Server released?
  • (A) 1991
  • (B) 1990
  • (C) 1988
  • (D) 1983
💬 Discuss
✅ Correct Answer: (C) 1988
📊 SQL Server
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
💬 Discuss
✅ Correct Answer: (D) SQL Server Express
📊 SQL Server
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
💬 Discuss
✅ Correct Answer: (D) All of the Mentioned
📊 SQL Server
Q. What is the Codename for SQL Server 2012?
  • (A) Katmai
  • (B) Denali
  • (C) Hekaton
  • (D) Kilimanjaro
💬 Discuss
✅ Correct Answer: (B) Denali
📊 SQL Server
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
💬 Discuss
✅ Correct Answer: (D) SQL Server 2014
📊 SQL Server
Q. Which of the following data type is not present in SQL Server?
  • (A) geography
  • (B) hierarchyid
  • (C) boolean
  • (D) bit
💬 Discuss
✅ Correct Answer: (C) boolean
📊 SQL Server
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
💬 Discuss
✅ Correct Answer: (C) msdb
📊 SQL Server
Q. SQL Server has mainly how many types of views?
  • (A) four
  • (B) three
  • (C) one
  • (D) two
💬 Discuss
✅ Correct Answer: (D) two
📊 SQL Server
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
💬 Discuss
✅ Correct Answer: (A) sys.dm_exec_connections

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play