SQL Server MCQs with answers Page - 5

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. Which checkpoints runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion?

  • (A) Automatic
  • (B) Manual
  • (C) Indirect
  • (D) Internal

A

Admin • 828.03K Points
Coach

Q. How much maximum file can be there in one database?

  • (A) 65536
  • (B) 16384
  • (C) 32764
  • (D) 32767

A

Admin • 828.03K Points
Coach

Q. The size of the page is?

  • (A) 2 kb
  • (B) 4 kb
  • (C) 8 kb
  • (D) 16 kb

A

Admin • 828.03K Points
Coach

Q. Rollback operations are also logged

  • (A) TRUE
  • (B) FALSE
  • (C) Can be true or false
  • (D) Can not say

A

Admin • 828.03K Points
Coach

Q. How many types of file groups in SQL Server?

  • (A) 1
  • (B) 2
  • (C) 3
  • (D) 4

A

Admin • 828.03K Points
Coach

Q. MS SQL Server developed by?

  • (A) Microsoft
  • (B) IBM
  • (C) Oracle
  • (D) Google

A

Admin • 828.03K Points
Coach

Q. Microsoft SQL Server Initial release on?

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

A

Admin • 828.03K Points
Coach

Q. Which of the following is an Advantages of Instances (SQL Server)?

  • (A) To reduce cost
  • (B) To reduce temporary database problems
  • (C) To separate security privileges
  • (D) All of the above

A

Admin • 828.03K Points
Coach

Q. How many protocol SQL Server has?

  • (A) 5
  • (B) 4
  • (C) 3
  • (D) 2

A

Admin • 828.03K Points
Coach

Q. In SQL Server 2012 how many types of checkpoints there?

  • (A) 6
  • (B) 5
  • (C) 4
  • (D) 3

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