SQL Server Questions and Answers – Specifications – 2

This set of tricky SQL Server questions and answers focuses on “Specifications – 2”.

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

Answer: a
Explanation: SQL Server 2012 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 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
View Answer

Answer: c
Explanation: Resource database is added to SQL Server 2012.

3. Which components of SQL Server 2014 require 1182 Mb?
a) SSIS
b) SSAS
c) Client components
d) SSRS
View Answer

Answer: c
Explanation: Client components does not include Integration tools for SQL Server 2012.
advertisement
advertisement

4. Which of the following is a feature of SQL Server 2014?
a) Column oriented database
b) Support for 32-bit and 64-bit processors
c) In memory database
d) All of the mentioned
View Answer

Answer: d
Explanation: SQL Server 2014 CTP 1 may contain branding from Microsoft SQL Server 2012 and is versioned as 11.0.

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

Answer: b
Explanation: There should be noSQL products other than SQL Server 2014 CTP1.
Note: Join free Sanfoundry classes at Telegram or Youtube

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

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

7. Which of the following operating system is supported by SQL Server 2014?
a) Windows Server 2012
b) Windows 8 RTM
c) Windows Vista SP2
d) All of the mentioned
View Answer

Answer: d
Explanation: These are minimum operating system requirements for the SQL Server 2014.
advertisement

8. Which of the following component is not installed by SQL Server setup 2012 required by the product?
a) .NET Framework 3.5 SP11
b) Named Pipes
c) SQL Server Setup support files
d) All of the mentioned
View Answer

Answer: b
Explanation: SQL Server Setup will block installations on read-only or compressed drives.

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

Answer: a
Explanation: The minimum processing requirement is a 1.0GHz CPU for a 32-bit x86 implementation and a 1.4GHz CPU for a 64-bit x64 implementation. Microsoft’s recommended minimum processor speed is 2.0GHz.

advertisement

10. The supported storage types for data files are ___________
a) RAM
b) Hard Storage
c) SMB File Share
d) None of the mentioned
View Answer

Answer: c
Explanation: SMB storage can be hosted by a Windows File Server or a third party SMB storage device.

Sanfoundry Global Education & Learning Series – SQL Server.

To practice tricky questions and answers on 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.