Question 11 : What does the SQL Server setup program requires ?
1. Named Pipes
2. Shared Memory
3. Microsoft Windows Installer 4.5
4. All of the mentioned
View Answer   Discuss with Members

Question 12 : Which of the following operating system is Supported by IA-64 Edition ?
1. Windows Server 2003 R2 SP2 64-bit Itanium Datacenter
2. Windows Server 2003 SP2 64-bit x64 Datacenter
3. Windows Server 2003 SP2 64-bit x64 Enterprise
4. Windows Server 2003 SP2 64-bit x64 Standard
View Answer   Discuss with Members

Question 13 : Which of the following is not a feature of SQL Server 2008 R2 Enterprise ?
1. Hot-add CPU
2. Hot-add RAM
3. Database partitioning
4. In memory database
View Answer   Discuss with Members

Question 14 : Point out the wrong statement :
1. The Datacenter edition provides the maximum scalability of the different SQL Server 2008 R2 editions
2. The Datacenter edition is priced at $11,990 per processor
3. There are several different editions of SQL Server
4. None of the mentioned
View Answer   Discuss with Members

Question 15 : Which of the following is a feature of SQL Server 2008 R2 Datacenter ?
1. StreamInsight Premium real-time event processing
2. Support for 32-bit and 64-bit processors
3. Support for up to 256 logical CPUs
4. All of the mentioned
View Answer   Discuss with Members

Question 16 : Which are the SQL Server 2008 R2 components require space more than 1.5 Gb ?
1. SSIS
2. SSAS
3. Client components
4. SSRS
View Answer   Discuss with Members

Question 17 : Point out the correct statement :
1. SQL Server books online is part of Microsoft SQL Server
2. SQL Server books online is not a part of Microsoft SQL Server
3. SQL Server books online needs to be downloaded separately
4. None of the mentioned
View Answer   Discuss with Members

Question 18 : What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine ?
1. 811 Mb
2. 711 Mb
3. 611 Mb
4. 511 Mb
View Answer   Discuss with Members