SQL Server interview questions part 27
SQL Server interview questions part 27
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Point out the wrong statement :
Correct Answer is : The maintenance of Service Broker is difficult
2. Service Broker also provides security by preventing __________ access from networks and by message encryption.
Correct Answer is : Unauthorized
3. (SSBS) is a new architecture which allows you to write ____________ message based application.
Correct Answer is : all of the mentioned
4. Which of the following change was introduced in SQL Server 2012 related to Service Broker?
Correct Answer is : Messages can be sent to multiple target services (multicast)
5. Which of the following is a Service Broker Related Dynamic Management View ?
Correct Answer is : sys.dm_broker_activated_tasks
6. Which of the utility is used for reporting issue in Service Broker ?
Correct Answer is : ssbdiagnose
7. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine ?
Correct Answer is : 711 Mb
8. Point out the correct statement :
Correct Answer is : SQL Server books online needs to be downloaded separately
9. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb ?
Correct Answer is : Client components
10. Which of the following is a feature of SQL Server 2008 R2 Datacenter ?
Correct Answer is : Support for 32-bit and 64-bit processors
11. Point out the wrong statement :
Correct Answer is : The Datacenter edition is priced at $11,990 per processor
12. Which of the following is not a feature of SQL Server 2008 R2 Enterprise ?
Correct Answer is : In memory database
13. Which of the following operating system is Supported by IA-64 Edition ?
Correct Answer is : Windows Server 2003 R2 SP2 64-bit Itanium Datacenter
14. What does the SQL Server setup program requires ?
Correct Answer is : Shared Memory
15. Which is minimum processor speed for SQL Server 2008 ?
Correct Answer is : 1.4 GHz
16. The main memory requirements for SQL Server 2008 includes :
Correct Answer is : Minimum:512 MB
17. What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine ?
Correct Answer is : 811 Mb
18. Point out the correct statement :
Correct Answer is : Resource database is part of System database
19. Which components of SQL Server 2014 require 1182 Mb ?
Correct Answer is : Client components
20. Which of the following is a feature of SQL Server 2014 ?
Correct Answer is : All of the mentioned
