SQL Server MCQs with answers Page - 25

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

Q. Which of these tools analyse as well as highlights those data rows that do NOT match the general patterns of the rest of the table?

  • (A) Highlight
  • (B) Exceptions
  • (C) Highlight Exceptions
  • (D) Scenario Analysis

A

Admin • 833.24K Points
Coach

Q. What is the Space Requirement for the SQL Server 2012 R2 Hard Disk for the database engines?

  • (A) 511 MegaBytes
  • (B) 611 MegaBytes
  • (C) 711 MegaBytes
  • (D) 811 MegaBytes

A

Admin • 833.24K Points
Coach

Q. Which of these would hold some set of temporary data?

  • (A) Msdb
  • (B) Tempdb
  • (C) Master
  • (D) Northwind

A

Admin • 833.24K Points
Coach

Q. How do we delete a login ?

  • (A) DELETE LOGIN login_name
  • (B) DROP LOGIN login_name
  • (C) A login cannot be deleted but only disabled
  • (D) DISABLE LOGIN login_name

A

Admin • 833.24K Points
Coach

Q. In which database state, the database is in single-user mode and may be repaired or restored.

  • (A) OFFLINE
  • (B) SUSPECT
  • (C) EMERGENCY
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. CREATE DATABASE has how many mandatory parameters?

  • (A) 1
  • (B) 2
  • (C) 3
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. For every unique constraint on a column, SQL server will create

  • (A) Does not create any index
  • (B) clustered index for that column
  • (C) index for that column
  • (D) non-clustered index for that column

A

Admin • 833.24K Points
Coach

Q. Which operation, when performed on a database can throw an error

  • (A) “The database could not be exclusively locked to perform the operation”
  • (B) DELETE database
  • (C) DROP database
  • (D) Rename database

A

Admin • 833.24K Points
Coach

Q. What is the syntax for creating new login on the SQL sevrer?

  • (A) USE LOGIN login_id WITH PASSWORD password
  • (B) CREATE LOGIN login_id WITH USE password
  • (C) CREATE LOGIN login_id USE password
  • (D) CREATE LOGIN login_id WITH PASSWORD password

A

Admin • 833.24K Points
Coach

Q. An index can be defined for a single column

  • (A) True
  • (B) False
  • (C) NA
  • (D) NA

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.