MCQs
Total Questions : 10
Answer: Option C. -> Resource database is part of System database
Resource database is added to SQL Server 2012.
Answer: Option B. -> Support for 32-bit and 64-bit processors
SQL Server 2008 R2 Datacenter provides the complete feature set available in SQL Server 2008.
Answer: Option C. -> SQL Server books online needs to be downloaded separately
SQL Server Online 2008 books occupy 157 Mb.
Answer: Option B. -> The Datacenter edition is priced at $11,990 per processor
The Datacenter edition is priced at $13,748 if you have Software Assurance (SA).
Answer: Option C. -> Client components
Client components does not include SSIS tools.
Answer: Option D. -> In memory database
In-memory database capability is provided by 2012.
Answer: Option D. -> All of the mentioned
These are minimum operating system requirements for the SQL Server 2014.
Answer: Option B. -> Named Pipes
SQL Server Setup will block installations on read-only or compressed drives.
Answer: Option A. -> 1.4 GHz
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.
Answer: Option C. -> SMB File Share
SMB storage can be hosted by a Windows File Server or a third party SMB storage device.
Latest Videos
Latest Test Papers
Login With Google
Old way of Login
Login With Email