Knowledge of SQL Server 2008
 

  1. Question: Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?

    A
    Hot Add CPU

    B
    Dynamic management views

    C
    Resource Governor

    D
    Backup Compression

    Note: Not available
    1. Report

  2. Question: Which data type of SQL Server 2008 converts itself into the type of data that is inserted into it?

    A
    real

    B
    rowversion

    C
    type_var

    D
    sql_variant

    E
    monetary

    Note: Not available
    1. Report

  3. Question: Analyze the following command: -o "C:Folder<file_name>" Which of the following statements is true if a file with the file name specified in the above command already exists?

    A
    An error is generated.

    B
    The file is overwritten

    C
    None of these

    Note: Not available
    1. Report

  4. Question: Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.

    A
    True

    B
    False

    Note: Not available
    1. Report

  5. Question: A local temporary stored procedure name can contain a maximum of ______ characters.

    A
    58

    B
    116

    C
    128

    D
    512

    Note: Not available
    1. Report

  6. Question: Analyze the following code using wild card characters of SQL Server 2008:
    SELECT Name
FROM person.employees
WHERE Name LIKE '[_]n'
GO
    Which of the following values will be returned by the above code?

    A
    in

    B
    sin

    C
    _n

    D
    All of these

    Note: Not available
    1. Report

  7. Question: Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?

    A
    Windows Authentication

    B
    SQL Server Authentication

    C
    IIS Authentication

    D
    Digest Authentication

    Note: Not available
    1. Report

  8. Question: All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.

    A
    True

    B
    False

    Note: Not available
    1. Report

  9. Question: Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?

    A
    core.sp_delete_data

    B
    core.sp_purge_data

    C
    core.sp_remove_data

    D
    None of these

    Note: Not available
    1. Report

  10. Question: What is the maximum number of processors that can be used in parallel plan execution using the MAXDOP option in SQL Server 2008?

    A
    32 processors

    B
    50 processors

    C
    64 processors

    D
    75 processors

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