Menu
Home / CSE MCQs / SQL Server MCQs :: SQL Server Beyond Relational

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.
    The full-text index includes only one character-based column in the table
    B.
    The full-text index includes more than one character-based columns in the table
    C.
    The full-text index includes one or more character-based columns in the table
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Full-text search is an ________ component of the SQL Server Database Engine
    3. A.
    slower
    B.
    optimal
    C.
    faster
    D.
    none of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Point out the correct statement :
    4. A.
    HierarchyID data type maps the data as a hashmap, so when traversing the binary tree structure
    B.
    In real scenarios, you always need to create indexes using HierarchyID data type
    C.
    In HierarchyID, we create indexes in order to make the traversal efficient
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Which of the following is not a XML storage option ?
    5. A.
    Native storage as XML data type
    B.
    Mapping between XML and relational storage
    C.
    Small object storage
    D.
    None of the Mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. The choice of XML technology, native XML versus XML view, generally depends upon the following factors:
    6. A.
    Storage options
    B.
    Query capabilities
    C.
    Indexing
    D.
    All of the Mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. The space use of XML indexes can be found in the table-valued function named?
    7. A.
    sys.dm_db_index_physical_stats
    B.
    sys.dm_db_index_phy_stats
    C.
    sys.dm_db_index_plan_stats
    D.
    sys.dm_db_index_table_stats

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. SQL Server lets you define how many types of secondary XML indexes?
    8. A.
    3
    B.
    4
    C.
    5
    D.
    6

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Statement for dropping XML index is :
    9. A.
    DROP INDEX
    B.
    DELETE INDEX
    C.
    REMOVE INDEX
    D.
    None of the Mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Different xml modes available for xml clauses are :
    10. A.
    RAW
    B.
    AUTO
    C.
    PATH
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. What is every identifier in an XQuery called ?
    11. A.
    Name
    B.
    QName
    C.
    Qidt
    D.
    Qnam

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers