SQL Server MCQs with answers Page - 23

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. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?

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

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

Q. Point out the correct statement.

  • (A) SQL Server books online is part of Microsoft SQL Server
  • (B) SQL Server books online is not a part of Microsoft SQL Server
  • (C) SQL Server books online needs to be downloaded separately
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (C) SQL Server books online needs to be downloaded separately

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

Q. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?

  • (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:44 pm in SQL Server

Q. Which of the following is a feature of SQL Server 2008 R2 Datacenter?

  • (A) StreamInsight Premium real-time event processing
  • (B) Support for 32-bit and 64-bit processors
  • (C) Support for up to 256 logical CPUs
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (B) Support for 32-bit and 64-bit processors

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

Q. Point out the wrong statement.

  • (A) The Datacenter edition provides the maximum scalability of the different SQL Server 2008 R2 editions
  • (B) The Datacenter edition is priced at $11,990 per processor
  • (C) There are several different editions of SQL Server
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (B) The Datacenter edition is priced at $11,990 per processor

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

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

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

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

Q. Which of the following operating system is Supported by IA-64 Edition?

  • (A) Windows Server 2003 SP2 64-bit x64 Standard
  • (B) Windows Server 2003 SP2 64-bit x64 Enterprise
  • (C) Windows Server 2003 SP2 64-bit x64 Datacenter
  • (D) Windows Server 2003 R2 SP2 64-bit Itanium Datacenter
💬 Discuss
✅ Correct Answer: (D) Windows Server 2003 R2 SP2 64-bit Itanium Datacenter

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

Q. What does the SQL Server setup program require?

  • (A) Named Pipes
  • (B) Shared Memory
  • (C) Microsoft Windows Installer 4.5
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (B) Shared Memory

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

Q. The @@NESTLEVEL function would fall under which of these categories?

  • (A) Data Functions of Date and Time
  • (B) Mathematical Functions
  • (C) Cursor Functions
  • (D) Configuration Functions
💬 Discuss
✅ Correct Answer: (D) Configuration Functions

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:01 am in SQL Server

Q. Which of these commands is used if we want in a PowerShell to get child items?

  • (A) Set-Alias
  • (B) Get-Child
  • (C) Get-ChildItem
  • (D) Get-Command
💬 Discuss
✅ Correct Answer: (C) Get-ChildItem

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:01 am 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