TechPetPro

Mssql MCQs (Multiple Choice Questions) with Answers

Microsoft SQL Server MCQ Quiz (Multiple Choice Questions And Answers). Are you preparing for the next job interviews? If yes, trust me this post will help you. Take SQL Server MCQ Test to test your knowledge. Test and improve your knowledge of the fundamentals of SQL Server with these multiple-choice questions.

You should read all the answers provided and click on the correct answer. If you are unsure of the answer you can check the answer on clicking the Show Answer Button.

RELATED TOPICS

MSSQL MCQs

Q.1
To developed MS SQL, which of the following programming language used ?
  • Python
  • C
  • C++
  • Both B & C
Answer: Both B & C [Option: D]
Q.2
MS SQL Server is a _________________?
  • Relational database
  • Personal database
  • Centralised database
  • Distributed database
Answer: Relational database [Option: A]
Q.3
To change Storage Characteristics of a table, ___________ command used?
  • modify table
  • trancuate table
  • alter table
  • change table
Answer: alter table [Option: C]
Q.4
SSAS stands for _______________-?
  • SQL System Analysis Services
  • SQL Support Analysis Services
  • SQL Server Analog Services
  • SQL Server Analysis Services
Answer: SQL Server Analysis Services [Option: D]
Q.5
Microsoft SQL Server _______ includes a component called SQL Common Language Runtime which integrates with .NET Framework.
  • 2005
  • 2008
  • 2003
  • 2006
Answer: 2005 [Option: A]
Q.6
_______________ is Microsoft's proprietary procedural language extension for SQL Server.
  • Native Client Server
  • SQL CLR
  • Transact SQL
  • None of above
Answer: Transact SQL [Option: C]