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
0 h : 0 m : 1 s