MCQGeeks
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Sql Server
Sqlserver Tricky
Quiz 1
Solution
Q.1.
What is SQL ServerR2 Hard Disk Space Requirement for database engine?
a) 811 Mb
b) 711 Mb
c) 611 Mb
d) 511 Mb
Q.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
Q.3.
Which components of SQL ServerrequireMb?
a) SSIS
b) SSAS
c) Client components
d) SSRS
Q.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
Q.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
Q.6.
Which of the following is a feature of SQL ServerR2 Enterprise?
a) In memory database
b) Hot-add RAM
c) Database partitioning
d) All of the mentioned
Q.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
Q.8.
Which of the following component is not installed by SQL Server setuprequired by the product?
a) .NET Framework 3.5 SP11
b) Named Pipes
c) SQL Server Setup support files
d) All of the mentioned
Q.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
Q.10.
The supported storage types for data files are ___________
a) RAM
b) Hard Storage
c) SMB File Share
d) None of the mentioned
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page