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

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

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

A

Admin • 833K Points
Coach

Q. The size of the page is?

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

A

Admin • 833K Points
Coach

Q. Rollback operations are also logged

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

A

Admin • 833K Points
Coach

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

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

A

Admin • 833K Points
Coach

Q. MS SQL Server developed by?

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

A

Admin • 833K Points
Coach

Q. Microsoft SQL Server Initial release on?

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

A

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

Browse Categories

Click on category to learn MCQs of that category.