Menu
Home / CSE MCQs / SQL Server MCQs :: SQL Server Specifications

CSE MCQs :: SQL Server MCQs

SQL Server MCQs - SQL Server Security
SQL Server MCQs - SQL Server Specifications
SQL Server MCQs - SQL Server Beyond Relational
SQL Server MCQs - SQL Server Data Connectivity
SQL Server MCQs - SQL Server Laying Foundation
SQL Server MCQs - SQL Server Manipulating Data
SQL Server MCQs - SQL Server Monitoring, Auditing
SQL Server MCQs - SQL Server Business Intelligence
SQL Server MCQs - SQL Server Developing with SQL Server
SQL Server MCQs - SQL Server Enterprise Data Management
SQL Server MCQs - SQL Server Performance Tuning,Optimization
  1. Point out the correct statement :
    2. 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

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Point out the correct statement :
    3. A.
    SQL Server books online is part of Microsoft SQL Server
    B.
    SQL Server books online is not a part of Microsoft SQL Server
    C.
    SQL Server books online needs to be downloaded separately
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb ?
    4. A.
    SSIS
    B.
    SSAS
    C.
    Client components
    D.
    SSRS

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Which of the following is a feature of SQL Server 2008 R2 Datacenter ?
    5. A.
    StreamInsight Premium real-time event processing
    B.
    Support for 32-bit and 64-bit processors
    C.
    Support for up to 256 logical CPUs
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Point out the wrong statement :
    6. A.
    The Datacenter edition provides the maximum scalability of the different SQL Server 2008 R2 editions
    B.
    The Datacenter edition is priced at $11,990 per processor
    C.
    There are several different editions of SQL Server
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Which of the following is not a feature of SQL Server 2008 R2 Enterprise ?
    7. A.
    Hot-add CPU
    B.
    Hot-add RAM
    C.
    Database partitioning
    D.
    In memory database

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. Which of the following operating system is supported by SQL Server 2014?
    8. A.
    Windows Server 2012
    B.
    Windows 8 RTM
    C.
    Windows Vista SP2
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the following component is not installed by SQL Server setup 2012 required by the product ?
    9. A.
    .NET Framework 3.5 SP11
    B.
    Named Pipes
    C.
    SQL Server Setup support files
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Which is minimum processor speed for SQL Server 2012 ?
    10. A.
    1.4 GHz
    B.
    2.4 GHz
    C.
    3.4 GHz
    D.
    4.4 GHz

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. The supported storage types for data files are :
    11. A.
    RAM
    B.
    Hard Storage
    C.
    SMB File Share
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers