.Net Technology - Upwork
 

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

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

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

  4. Question: How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?

    A
    n (n= number of expressions in the element list passed to CUBE)

    B
    n+1 (n= number of expressions in the element list passed to CUBE)

    C
    2^n (n= number of expressions in the element list passed to CUBE)

    D
    2^n+1 (n= number of expressions in the element list passed to CUBE)

    Note: Not available
    1. Report

  5. Question: Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?

    A
    Server Audit object

    B
    Server Audit Specification object

    C
    Database Audit Specification object

    D
    None of these

    Note: Not available
    1. Report

  6. Question: Windows Security log can be specified as a target for Audit in SQL Server 2008.

    A
    True

    B
    False

    Note: Not available
    1. Report

  7. Question: Which of the following is a valid code to delete a clustered index with a PRIMARY KEY constraint in SQL Server 2008?

    A
    LTER TABLE Production.ProductCost DROP CONSTRAINT PK_Product WITH (ONLINE = ON) GO

    B
    ALTER TABLE Production.ProductCostHistory DROP CONSTRAINT PK_Product DROP INDEX Index_Product WITH (ONLINE = ON) GO

    C
    DROP INDEX Index_Product ON Production.ProductCost GO

    D
    None of these

    Note: Not available
    1. Report

  8. Question: What is the default timeout for login to sqlcmd while you try to connect to a server?

    A
    5 seconds

    B
    8 seconds

    C
    10 seconds

    D
    15 seconds

    E
    1 minute

    Note: Not available
    1. Report

  9. Question: What is the default precision of the date data type in SQL Server 2008?

    A
    4 digits

    B
    6 digits

    C
    8 digits

    D
    10 digits

    Note: Not available
    1. Report

  10. Question: What amount of storage is required by a date variable in SQL Server 2008?

    A
    3 bytes

    B
    5 bytes

    C
    6 bytes

    D
    8 bytes

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