SQL Server MCQs with answers Page - 20

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. Dynamic Management View is a type of ___________

  • (A) Complex View
  • (B) Simple View
  • (C) User Defined View
  • (D) System Defined Views
💬 Discuss
✅ Correct Answer: (D) System Defined Views

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:19 pm in SQL Server

Q. The main memory requirements for SQL Server 2008 includes ___________

  • (A) Maximum:512 MB
  • (B) Maximum:252 MB
  • (C) Minimum:1 GB
  • (D) Minimum:512 MB
💬 Discuss
✅ Correct Answer: (D) Minimum:512 MB

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:23 pm in SQL Server

Q. What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine?

  • (A) 811 Mb
  • (B) 711 Mb
  • (C) 611 Mb
  • (D) 511 Mb
💬 Discuss
✅ Correct Answer: (A) 811 Mb

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:23 pm in SQL Server

Q. Point out the correct statement.

  • (A) SQL Server books online is part of Microsoft SQL Server 2012
  • (B) SQL Server books online is not a part of Microsoft SQL Server 2008
  • (C) Resource database is part of System database
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (C) Resource database is part of System database

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:24 pm in SQL Server

Q. Which components of SQL Server 2014 require 1182 Mb?

  • (A) SSRS
  • (B) Client components
  • (C) SSAS
  • (D) SSIS
💬 Discuss
✅ Correct Answer: (B) Client components

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:25 pm in SQL Server

Q. Which of the following is a feature of SQL Server 2014?

  • (A) Support for 32-bit and 64-bit processors
  • (B) Column oriented database
  • (C) In memory database
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:25 pm in SQL Server

Q. Point out the wrong statement related to SQL Server 2014.

  • (A) SQL Server 2014 CTP 1 is pre-release software and should be installed only on a clean machine
  • (B) SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments
  • (C) SQL Server 2014 CTP 1 is only available in the English language
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (B) SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:26 pm in SQL Server

Q. Which of the following is a feature of SQL Server 2012 R2 Enterprise?

  • (A) Database partitioning
  • (B) In memory database
  • (C) Hot-add RAM
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:26 pm in SQL Server

Q. Which of the following operating system is supported by SQL Server 2014?

  • (A) Windows Vista SP2
  • (B) Windows Server 2012
  • (C) Windows 8 RTM
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:27 pm in SQL Server

Q. Which of the following component is not installed by SQL Server setup 2012 required by the product?

  • (A) SQL Server Setup support files
  • (B) .NET Framework 3.5 SP11
  • (C) Named Pipes
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (C) Named Pipes

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:27 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