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

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

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

A

Admin • 832.27K Points
Coach

Q. The size of the page is?

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

A

Admin • 832.27K Points
Coach

Q. Rollback operations are also logged

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

A

Admin • 832.27K Points
Coach

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

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

A

Admin • 832.27K Points
Coach

Q. MS SQL Server developed by?

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

A

Admin • 832.27K Points
Coach

Q. Microsoft SQL Server Initial release on?

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

A

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

Q. How many protocol SQL Server has?

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

A

Admin • 832.27K 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