.Net Technology - Upwork
 

  1. Question: What happens to the audit records if a failure to write the Audit event does NOT trigger the SQL Server instance to shut down?

    A
    The server blocks any new activity to be performed to the SQL Server instance.

    B
    Audit events are buffered in memory until they can be flushed to the target.

    C
    The audit is automatically disabled.

    D
    An error is displayed.

    Note: Not available
    1. Report

  2. Question: Which of the following code snippets causes only partition number 1 to be rebuilt while changing the compression of a partitioned table?

    A
    ALTER TABLE Table1 REBUILD WITH (DATA_COMPRESSION = PAGE)

    B
    ALTER TABLE Table1 REBUILD PARTITION = 1 WITH (DATA_COMPRESSION = NONE) GO

    C
    ALTER TABLE Table1 REBUILD PARTITION ALL WITH (DATA_COMPRESSION = PAGE ON PARTITIONS(1) )

    D
    All of these

    Note: Not available
    1. Report

  3. Question: Analyze the following data types and schemas: 1.The SQL Server system data type. 2.The default schema of the current user in the current database. 3.The dbo schema in the current database. In which order does the SQL Server Database Engine refer to type_name when a type_schema_name is NOT specified while creating a table in SQL Server 2008?

    A
    3,2,1

    B
    2,3,1

    C
    3,1,2

    D
    1,2,3

    E
    Any order

    Note: Not available
    1. Report

  4. Question: Which of the following options is NOT supported by the ON DELETE clause of a FOREIGN KEY constraint of SQL Server 2008?

    A
    CASCADE

    B
    DELETE

    C
    SET NULL

    D
    SET DEFAULT

    Note: Not available
    1. Report

  5. Question: Suppose you create a stored procedure and save it in the database with "sp_" prefix. Which of the following statements is true regarding the execution of the stored procedure?

    A
    The prefix will speed up the execution of the stored procedure.

    B
    The prefix will slow down the execution of the stored procedure.

    C
    The performance of the stored procedure is not affected.

    D
    All of these

    Note: Not available
    1. Report

  6. Question: Each table in SQL Server 2008 can have up to ______ nonclustered indexes.

    A
    777

    B
    888

    C
    999

    D
    1000

    Note: Not available
    1. Report

  7. Question: Analyze the following code which uses the TOP clause of SQL Server 2008:
    USE Person
GO
DECLARE @p AS int
SELECT @p=10
SELECT TOP(@p)
FROM Employee
GO
    What Will be the output of the above code?

    A
    No output is displayed.

    B
    A list of first 10 employees is displayed from the Person database.

    C
    An incorrect syntax error is displayed.

    D
    None of these.

    Note: Not available
    1. Report

  8. Question: Which of the following is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?

    A
    ALTER DATABASE DROP ENCRYPTION KEY

    B
    DROP DATABASE ENCRYPTION KEY

    C
    ALTER DATABASE REMOVE ENCRYPTION KEY

    D
    REMOVE DATABASE ENCRYPTION KEY

    Note: Not available
    1. Report

  9. Question: What should a computed column be marked as so that SQL Server Database Engine can physically store values in a table?

    A
    ON

    B
    WRITE

    C
    PERSISTED

    D
    All of these

    Note: Not available
    1. Report

  10. Question: The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of ______ return type.

    A
    varchar

    B
    boolean

    C
    int

    D
    tinyint

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