Knowledge of SQL Server 2008

  1. Question: Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?

    A
    SELECT Column1 + Column2 FROM Table GROUP BY Column1, Column2

    B
    SELECT Column1, Column2 FROM Table GROUP BY Column1 + Column2

    C
    SELECT Column1 + constant + Column2 FROM Table GROUP BY Column1 + Column2

    D
    SELECT Column1 + Column2 FROM Table GROUP BY Column1 + Column2

    Note: Not available
    1. Report

  2. Question: What is the function of DBCC CHECKDB command in SQL Server 2008?

    A
    It checks the allocation of all the objects in the specified database.

    B
    It checks the structural integrity of all the objects in the specified database.

    C
    t checks for consistency in and between system tables in the specified database.

    D
    It checks the consistency of disk space allocation structures of a specified database.

    Note: Not available
    1. Report

  3. Question: Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?

    A
    Row-level compression

    B
    Page-level compression

    C
    Data file level compression

    D
    Backup level compression

    Note: Not available
    1. Report

  4. Question: Which of the following rules must be followed for combining the result sets of two queries by using UNION?

    A
    The number of columns must be same in all queries.

    B
    The order of columns must be same in all queries.

    C
    The data types of the columns of the queries must be compatible.

    D
    There should be at least one common column in the tables which are part of the UNION operation.

    Note: Not available
    1. Report

  5. Question: Which of the following scripting options are available while creating a script using the shortcut menu from the Object Explorer in SQL Server 2008 Management Studio?

    A
    DELETE To

    B
    MERGE To

    C
    CREATE INDEX To

    D
    NSERT To

    E
    UPDATE To

    Note: Not available
    1. Report

  6. Question: Which of the following options are available for the DATA_COMPRESSION clause specified for a table in SQL Server 2008?

    A
    Page

    B
    Table

    C
    Row

    D
    Column

    Note: Not available
    1. Report

  7. Question: Which of the following methods can be specified for the lock escalation of a table in SQL Server 2008?

    A
    ENABLE

    B
    AUTO

    C
    DISABLE

    D
    TABLE

    E
    DEFAULT

    Note: Not available
    1. Report

  8. Question: Which of the following data types are supported by SQL Server 2008?

    A
    date

    B
    datetime

    C
    datetime1

    D
    datetime2

    E
    datetimeoffset

    Note: Not available
    1. Report

  9. Question: Which of the following formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?

    A
    Integer

    B
    Binary

    C
    Decimal

    D
    Hexadecimal

    Note: Not available
    1. Report

  10. Question: Which of the following statements are true?

    A
    IGNORE_DUP_KEY cannot be set to ON for XML indexes.

    B
    IGNORE_DUP_KEY can be set to ON for spatial indexes.

    C
    IGNORE_DUP_KEY can be set to ON for filtered indexes.

    D
    IGNORE_DUP_KEY can be set to ON for XML indexes.

    E
    IGNORE_DUP_KEY cannot be set to ON for indexes created on a view.

    Note: Not available
    1. Report
First123Last
/11
Copyright © 2024. Powered by Intellect Software Ltd