Specifications MCQ

Test your knowledge with important Specifications MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Specifications MCQs at Bissoy

• The supported storage types for data files are ___________
  ক

  RAM

  খ

  Hard Storage

  গ

  SMB File Share

  ঘ

  None of the mentioned
• Which is the minimum processor speed for SQL Server 2012?
  ক

  1.4 GHz

  খ

  2.4 GHz

  গ

  3.4 GHz

  ঘ

  4.4 GHz
• Which of the following component is not installed by SQL Server setup 2012 required by the product?
  ক

  .NET Framework 3.5 SP11

  খ

  Named Pipes

  গ

  SQL Server Setup support files

  ঘ

  All of the mentioned
• Which of the following operating system is supported by SQL Server 2014?
  ক

  Windows Server 2012

  খ

  Windows 8 RTM

  গ

  Windows Vista SP2

  ঘ

  All of the mentioned
• Which of the following is a feature of SQL Server 2012 R2 Enterprise?
  ক

  In memory database

  খ

  Hot-add RAM

  গ

  Database partitioning

  ঘ

  All of the mentioned
• Point out the wrong statement related to SQL Server 2014.
  ক

  SQL Server 2014 CTP 1 is pre-release software and should be installed only on a clean machine

  খ

  SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments

  গ

  SQL Server 2014 CTP 1 is only available in the English language

  ঘ

  None of the mentioned
• Which of the following is a feature of SQL Server 2014?
  ক

  Column oriented database

  খ

  Support for 32-bit and 64-bit processors

  গ

  In memory database

  ঘ

  All of the mentioned
• Which components of SQL Server 2014 require 1182 Mb?
  ক

  SSIS

  খ

  SSAS

  গ

  Client components

  ঘ

  SSRS
• What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine?
  ক

  811 Mb

  খ

  711 Mb

  গ

  611 Mb

  ঘ

  511 Mb
• The main memory requirements for SQL Server 2008 includes ___________
  ক

  Minimum:512 MB

  খ

  Minimum:1 GB

  গ

  Maximum:252 MB

  ঘ

  Maximum:512 MB
• Which is the minimum processor speed for SQL Server 2008?
  ক

  1.4 GHz

  খ

  2.4 GHz

  গ

  3.4 GHz

  ঘ

  4.4 GHz
• What does the SQL Server setup program require?
  ক

  Named Pipes

  খ

  Shared Memory

  গ

  Microsoft Windows Installer 4.5

  ঘ

  All of the mentioned
• Which of the following operating system is Supported by IA-64 Edition?
  ক

  Windows Server 2003 R2 SP2 64-bit Itanium Datacenter

  খ

  Windows Server 2003 SP2 64-bit x64 Datacenter

  গ

  Windows Server 2003 SP2 64-bit x64 Enterprise

  ঘ

  Windows Server 2003 SP2 64-bit x64 Standard
• Which of the following is not a feature of SQL Server 2008 R2 Enterprise?
  ক

  Hot-add CPU

  খ

  Hot-add RAM

  গ

  Database partitioning

  ঘ

  In memory database
• Which of the following is a feature of SQL Server 2008 R2 Datacenter?
  ক

  StreamInsight Premium real-time event processing

  খ

  Support for 32-bit and 64-bit processors

  গ

  Support for up to 256 logical CPUs

  ঘ

  All of the mentioned
• Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?
  ক

  SSIS

  খ

  SSAS

  গ

  Client components

  ঘ

  SSRS
• What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?
  ক

  811 Mb

  খ

  711 Mb

  গ

  611 Mb

  ঘ

  511 Mb