.Net Technology - Upwork
 

  1. 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

  2. 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

  3. 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

  4. Question: Which of the following statements are true regarding row and page compression in SQL Server 2008?

    A
    When a table or index is created, data compression is set to NONE, unless otherwise specified.

    B
    Nonclustered indexes inherit the compression property of the table.

    C
    New pages allocated in a heap as part of DML operations will not use PAGE compression until the heap is rebuilt.

    D
    When you are compressing indexes, leaf-level pages can be compressed with only page compression.

    Note: Not available
    1. Report

  5. Question: Which of the following security features have been introduced in SQL Server 2008?

    A
    Extensible Key Management

    B
    SOAP Security

    C
    Hashing

    D
    Transparent Data Encryption

    Note: Not available
    1. Report

  6. Question: Which of the following encryption algorithms are used by the Transparent Data Encryption security mechanism of SQL Server 2008?

    A
    Tiny Encryption Algorithm

    B
    Advanced Encryption Standard(AES)

    C
    Blowfish

    D
    Triple Data Encryption Standard(3DES)

    Note: Not available
    1. Report

  7. Question: Which of the following are valid DATETIME functions in SQL Server 2008?

    A
    SYSDATE()

    B
    SYSTIME()

    C
    SYSDATETIME()

    D
    SYSUTCDATETIME()

    Note: Not available
    1. Report

  8. Question: Which of the following counters are used to monitor compression of the whole instance of SQL Server?

    A
    Page compression attempts/sec

    B
    Row compression/sec

    C
    Pages compressed/min

    D
    Pages compressed/sec

    E
    Rows compressed/min

    Note: Not available
    1. Report

  9. Question: Which of the following statements are true about the FILESTREAM argument of SQL Server 2008?

    A
    If a table contains FILESTREAM data and the table is partitioned, the FILESTREAM_ON clause must be included.

    B
    The FILESTREAM column can be partitioned even if a table is not partitioned.

    C
    There may not be a FILESTREAM filegroup if a table is not partitioned and the FILESTREAM_ON clause is not specified.

    D
    The filegroup in the FILESTREAM_ON <filegroup>> clause must have one file defined for the filegroup.

    Note: Not available
    1. Report

  10. Question: Which of the following spatial data types are used in SQL Server 2008?

    A
    Geography

    B
    Longitude

    C
    Altitude

    D
    Geometry

    E
    Latitude

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