Knowledge of SQL Server 2008

  1. Question: For which of the following data types can a COLLATE clause be applied?

    A
    text

    B
    int

    C
    varchar

    D
    bigint

    Note: Not available
    1. Report

  2. Question: Columns marked with which of the following constraints/properties allow null values to be inserted in them?

    A
    PRIMARY KEY

    B
    UNIQUE

    C
    IDENTITY

    D
    FOREIGN KEY

    Note: Not available
    1. Report

  3. Question: Analyze the following code used to update a Common Table Expression:
    USE demodb
GO
DECLARE @a TABLE (ID int, Value int);
DECLARE @b TABLE (ID int, Value int);
INSERT @a VALUES (1, 10), (2, 20);
INSERT @b VALUES (1, 100),(2, 200);
WITH cte AS (SELECT * FROM @a)
UPDATE cte
SET Value = b.Value
FROM cte AS a
INNER JOIN @b AS b ON b.ID = a.ID
SELECT * FROM @a
GO
    What Will be the output of the above code?

    A
    ID Value ----- ----- 1 100 2 200

    B
    ID Value ----- ----- 1 10 2 100

    C
    ID Value ----- ----- 1 10 2 200

    D
    ID Value ----- ----- 1 100 2 100

    Note: Not available
    1. Report

  4. Question: The Server Audit object and the Server Audit Specification object of SQL Server 2008 share a _____ relationship.

    A
    One-to-one

    B
    One-to-many

    C
    Many-to-one

    D
    Many-to-many

    Note: Not available
    1. Report

  5. Question: What is the maximum value for the sum of the values of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools of SQL Server?

    A
    50

    B
    75

    C
    100

    D
    150

    E
    200

    Note: Not available
    1. Report

  6. Question: An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.

    A
    At sign(@)

    B
    Double number(##)

    C
    Underscore(_)

    D
    None of these

    Note: Not available
    1. Report

  7. Question: Which of the following features is used by SQL Server Audit to create and manage audits in SQL Server 2008?

    A
    System stored procedures

    B
    Triggers

    C
    SQL DDL syntax

    D
    None of these

    Note: Not available
    1. Report

  8. Question: What is returned by NULLIF if the two expressions that it compares are NOT equal?

    A
    It returns the first expression.

    B
    It returns the second expression.

    C
    It returns a null value.

    D
    It returns an error.

    Note: Not available
    1. Report

  9. Question: User defined data type columns can be designated with ROWGUIDCOL.

    A
    True

    B
    False

    Note: Not available
    1. Report

  10. 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
First12345Last
/11
Copyright © 2024. Powered by Intellect Software Ltd