Knowledge of SQL Server 2008
 

  1. Question: Analyze the following code snippet:
    DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01'
SELECT @myTime AS '@myTime'
    What is the output of the above code?

    A
    02:02:02.2345

    B
    02:02:02

    C
    02:02:02.2346

    D
    An error is displayed

    Note: Not available
    1. Report

  2. Question: Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

    A
    sqlcmd -S instanceName -o C:\new.txt

    B
    sqlcmd -S instanceName -i C:\myScript.sql -o C:\new.txt

    C
    sqlcmd -S myServer\instanceName -o C:\new.txt

    D
    sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\new.txt

    Note: Not available
    1. Report

  3. Question: Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?

    A
    sqlcmd

    B
    icrosoft .NET Framework SqlClient

    C
    OLE DB provider

    D
    None of these

    Note: Not available
    1. Report

  4. Question: What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?

    A
    ON

    B
    OFF

    C
    TRUE

    D
    FALSE

    Note: Not available
    1. Report

  5. Question: Which of the following statements is NOT true about the UNIQUE constraint of SQL Server 2008?

    A
    Multiple UNIQUE constraints can be defined on a table.

    B
    When using the UNIQUE constraint, only one null value is allowed per column.

    C
    UNIQUE constraint cannot be referenced by a FOREIGN KEY constraint

    D
    None

    Note: Not available
    1. Report

  6. Question: Which of the following options is used to change the value of the password variable and exit using sqlcmd?

    A
    -p

    B
    -P

    C
    -z

    D
    -Z

    Note: Not available
    1. Report

  7. Question: The regular identifiers of SQL Server 2008 may contain a range of _______ characters.

    A
    1 to 116

    B
    1 to 127

    C
    1 to 128

    D
    1 to 512

    Note: Not available
    1. Report

  8. Question: Which of the following evaluation modes of Policy-Based Management CANNOT be automated in SQL Server 2008?

    A
    On demand

    B
    On change: prevent

    C
    On change: log only

    D
    On schedule

    Note: Not available
    1. Report

  9. Question: Which of the following statements is true if you create a global temporary table in SQL Server 2008 and specify a FOREIGN KEY with the CREATE TABLE command?

    A
    The table is created successfully with the FOREIGN KEY constraint.

    B
    The table is not created and no message is returned.

    C
    The table is created without the FOREIGN KEY constraint and a warning message is returned.

    D
    The table is not created and an error message is displayed.

    Note: Not available
    1. Report

  10. Question: Which of the following features of SQL Server 2008 evaluates servers for compliance with a set of predefined conditions and prevents making undesirable changes to servers?

    A
    Data Compression

    B
    Resource Governor

    C
    Policy-Based Management

    D
    Auditing

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