SQL Server Questions and Answers – Specifications – 1

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Specifications – 1”.

1. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?
a) 811 Mb
b) 711 Mb
c) 611 Mb
d) 511 Mb
View Answer

Answer: b
Explanation: SQL Server 2008 R2 can run on both 32-bit and 64-bit systems.

2. 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
View Answer

Answer: c
Explanation: SQL Server Online 2008 books occupy 157 Mb.

3. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?
a) SSIS
b) SSAS
c) Client components
d) SSRS
View Answer

Answer: c
Explanation: Client components does not include SSIS tools.
advertisement
advertisement

4. 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
View Answer

Answer: b
Explanation: SQL Server 2008 R2 Datacenter provides the complete feature set available in SQL Server 2008.

5. 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
View Answer

Answer: b
Explanation: The Datacenter edition is priced at $13,748 if you have Software Assurance (SA).

6. Which of the following is not a feature of SQL Server 2008 R2 Enterprise?
a) Hot-add CPU
b) Hot-add RAM
c) Database partitioning
d) In memory database
View Answer

Answer: d
Explanation: In-memory database capability is provided by 2012.

7. Which of the following operating system is Supported by IA-64 Edition?
a) Windows Server 2003 R2 SP2 64-bit Itanium Datacenter
b) Windows Server 2003 SP2 64-bit x64 Datacenter
c) Windows Server 2003 SP2 64-bit x64 Enterprise
d) Windows Server 2003 SP2 64-bit x64 Standard
View Answer

Answer: a
Explanation: SQL Server 2008 R2 Enterprise is designed for large, highly scalable enterprise implementations.
advertisement

8. 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
View Answer

Answer: b
Explanation: All the x86 and x64 editions of SQL Server, except the SQL Server Express versions.

9. Which is the minimum processor speed for SQL Server 2008?
a) 1.4 GHz
b) 2.4 GHz
c) 3.4 GHz
d) 4.4 GHz
View Answer

Answer: a
Explanation: Recommended speed is 2.0 GHz or faster.
advertisement

10. The main memory requirements for SQL Server 2008 includes ___________
a) Minimum:512 MB
b) Minimum:1 GB
c) Maximum:252 MB
d) Maximum:512 MB
View Answer

Answer: a
Explanation: Recommended RAM is 2.048 GB or more for SQL Server 2008.

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.