Knowledge of SQL Server 2008

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

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

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

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

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

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

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

  8. Question: Which function/functions are performed by the following statement? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

    A
    It checks the current iDentity fielD value of the specifieD table.

    B
    It sets the identity field value to the new reseed value.

    C
    It sets the identity field value to 1.

    D
    All of these

    Note: Not available
    1. Report

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

    A
    Transact-SQL can be used to SELECT, INSERT, UPDATE, DELETE FILESTREAM data.

    B
    The size of the stored data is limited to 2 GB.

    C
    You cannot take backup of a database without the FILESTREAM data.

    D
    FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher.

    Note: Not available
    1. Report

  10. Question: Which of the following permissions are required to create a view in SQL Server 2008?

    A
    CREATE VIEW permission in database

    B
    ALTER permission on schema

    C
    CONTROL permission on object

    D
    All of these

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