SQL Server MCQs with answers Page - 5

Dear candidates you will find MCQ questions of SQL Server here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

R

Ram Sharma • 193.86K Points
Coach

Q. Which of the following lies between the host machine (Windows OS) and SQL Server?

  • (A) Storage Engine
  • (B) SQL OS
  • (C) Query Executor
  • (D) Query Optimizer

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach

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

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

R

Ram Sharma • 193.86K Points
Coach

Q. The size of the page is?

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

R

Ram Sharma • 193.86K Points
Coach

Q. Rollback operations are also logged

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

R

Ram Sharma • 193.86K Points
Coach

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

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

R

Ram Sharma • 193.86K Points
Coach

Q. MS SQL Server developed by?

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

R

Ram Sharma • 193.86K Points
Coach

Q. Microsoft SQL Server Initial release on?

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach

Q. How many protocol SQL Server has?

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

Loding content...

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.