Knowledge of SQL Server 2008
 

  1. Question: How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?

    A
    25

    B
    30

    C
    35

    D
    40

    Note: Not available
    1. Report

  2. Question: Which of the following data types can be specified as SPARSE?

    A
    image

    B
    text

    C
    nchar

    D
    geography

    Note: Not available
    1. Report

  3. Question: Analyze the following code snippet for creating a stored procedure in SQL Server 2008:
    CREATE PROCEDURE Person.GetEmployees
@LastName nvarchar(50),
@FirstName nvarchar(50)
AS
SET NOCOUNT ON
SELECT FirstName, LastName, JobTitle, Department
FROM Person.EmployeeDepartment
WHERE FirstName = @FirstName AND LastName = @LastName
GO
    Which of the following is a valid code to execute the GetEmployees stored procedure?

    A
    EXECUTE Person.GetEmployees N'John', N'Miller'

    B
    EXECUTE Person.GetEmployees N'John', N'Miller'

    C
    EXECUTE Person.GetEmployees @FirstName = N'John', @LastName = N'Miller'

    D
    All of these

    Note: Not available
    1. Report

  4. Question: Starting from the lowest, arrange the following operators in the order in which they produce results in an SQL WHERE query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE

    A
    1,4,3,2

    B
    4,1,2,3

    C
    3,2,1,4

    D
    2,4,1,3

    Note: Not available
    1. Report

  5. Question: What is the default maximum precision of decimal data type in SQL Server 2008?

    A
    16

    B
    18

    C
    38

    D
    48

    Note: Not available
    1. Report

  6. Question: What is the maximum number of columns that can be combined into a single composite index key?

    A
    8

    B
    16

    C
    32

    D
    64

    Note: Not available
    1. Report

  7. Question: Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?

    A
    DEFAULT

    B
    CONTENT

    C
    DOCUMENT

    D
    FILESTREAM

    Note: Not available
    1. Report

  8. Question: Which of the following is the correct order of steps to be followed while using the Transparent Data Encryption security feature of SQL Server 2008?

    A
    1. Create a database encryption key. 2. Create or obtain a certificate protected by the encryption key. 3. Create a master key and protect it by the certificate. 4. Set the database to use encryption.

    B
    1. Create a database encryption key. 2. Create a master key. 3. Create or obtain a certificate protected by the master key. 4. Set the database to use encryption.

    C
    1. Create a master key. 2. Create or obtain a certificate protected by the master key. 3. Create a database encryption key and protect it by the certificate. 4. Set the database to use encryption.

    D
    None of these

    Note: Not available
    1. Report

  9. Question: Which of the following commands is used to start the Resource Governor in SQL Server 2008?

    A
    ALTER Resource Governor Enable

    B
    ALTER Resource Governor Reconfigure

    C
    ALTER Resource Governor Set

    D
    None of these

    Note: Not available
    1. Report

  10. Question: Which of the following commands is used to connect to a named instance of SQL Server using the sqlcmd utility of SQL Server?

    A
    sqlcmd -C myServer\instanceName

    B
    sqlcmd -S instanceName

    C
    sqlcmd -C instanceName

    D
    sqlcmd -S myServer\instanceName

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