SQL Server MCQs with answers Page - 8

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 • 828.03K Points
Coach

Q. What do the letters in CRUD stand for?

  • (A) Crunch Read Uptime Downtime
  • (B) Create Run Unrun Data
  • (C) Craft Run Upload Database
  • (D) Create Read Update Delete

A

Admin • 828.03K Points
Coach

Q. SQL views can be used to hide?

  • (A) Complicated SQL syntax
  • (B) Columns
  • (C) Rows
  • (D) All of the above

A

Admin • 828.03K Points
Coach

Q. The SQL SELECT statement is capable of

  • (A) Projection
  • (B) Selection
  • (C) Protection & Security
  • (D) Both A & B

A

Admin • 828.03K Points
Coach

Q. Embedded SQL is which of the following?

  • (A) The process of making an application capable of generating specific SQL code on the fly.
  • (B) Hard-coded SQL statements in a program language such as Java.
  • (C) Hard-coded SQL statements in a procedure.
  • (D) Hard-coded SQL statements in a trigger.

A

Admin • 828.03K Points
Coach

Q. The arranging of data in a logical sequence is called

  • (A) Summarizing
  • (B) Sorting
  • (C) Classifying
  • (D) Rearranging

A

Admin • 828.03K Points
Coach

Q. Which of the SQL Server RTM included native support for managing XML data? Codename for SQL Server 2012 is __________

  • (A) 7.0Kilimanjaro
  • (B) 6.5Katmai
  • (C) 8Denali
  • (D) 9Hekaton

A

Admin • 828.03K Points
Coach

Q. SQL Server 2005 has the following features?

  • (A) Dynamic Management Views
  • (B) FILESTREAM
  • (C) Powerpivot
  • (D) In-memory capability

A

Admin • 828.03K Points
Coach

Q. _________ is a software application first launched with the Microsoft SQL Server 2005.

  • (A) Enterprise Manager
  • (B) Query Analyzer
  • (C) Business Intelligence Development Studio
  • (D) SQL Server Management Studio

A

Admin • 828.03K Points
Coach

Q. LocalDB was introduced in which of the following versions of SQL Server?

  • (A) 2008 R2
  • (B) 2014
  • (C) 2008
  • (D) 2012

A

Admin • 828.03K Points
Coach

Q. _________ is free database software running free SQL Server technology.

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

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

Browse Categories

Click on category to learn MCQs of that category.