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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

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

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

Q. What is the Codename for SQL Server 2012?

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

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

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

Q. SQL Server has mainly how many types of views?

  • (A) four
  • (B) three
  • (C) one
  • (D) two

R

Ram Sharma • 193.86K 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

Loding content...

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.