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

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
💬 Discuss
✅ Correct Answer: (B) SQL OS

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:47 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (B) Manual

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:47 pm in SQL Server

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

  • (A) 65536
  • (B) 16384
  • (C) 32764
  • (D) 32767
💬 Discuss
✅ Correct Answer: (D) 32767

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:49 pm in SQL Server

Q. The size of the page is?

  • (A) 2 kb
  • (B) 4 kb
  • (C) 8 kb
  • (D) 16 kb
💬 Discuss
✅ Correct Answer: (C) 8 kb

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:49 pm in SQL Server

Q. Rollback operations are also logged

  • (A) TRUE
  • (B) FALSE
  • (C) Can be true or false
  • (D) Can not say
💬 Discuss
✅ Correct Answer: (A) TRUE

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:50 pm in SQL Server

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

  • (A) 1
  • (B) 2
  • (C) 3
  • (D) 4
💬 Discuss
✅ Correct Answer: (B) 2

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:50 pm in SQL Server

Q. MS SQL Server developed by?

  • (A) Microsoft
  • (B) IBM
  • (C) Oracle
  • (D) Google
💬 Discuss
✅ Correct Answer: (A) Microsoft

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:51 pm in SQL Server

Q. Microsoft SQL Server Initial release on?

  • (A) 1991
  • (B) 1990
  • (C) 1989
  • (D) 1988
💬 Discuss
✅ Correct Answer: (C) 1989

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:51 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (D) All of the above

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:53 pm in SQL Server

Q. How many protocol SQL Server has?

  • (A) 5
  • (B) 4
  • (C) 3
  • (D) 2
💬 Discuss
✅ Correct Answer: (B) 4

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:53 pm in SQL Server

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play