250+ TOP MCQs on Specifications and Answers

Tricky SQL Server questions and answers focuses on “Specifications”.

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

Answer: a
Clarification: 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

Answer: c
Clarification: 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

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

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

Answer: d
Clarification: 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

Answer: b
Clarification: There should be noSQL products other than SQL Server 2014 CTP1.

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

Answer: d
Clarification: 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

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

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

Answer: b
Clarification: 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

Answer: a
Clarification: 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.

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

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