.Net Technology - Upwork
 

  1. Question: Which function/functions are performed by the following statement? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

    A
    It checks the current iDentity fielD value of the specifieD table.

    B
    It sets the identity field value to the new reseed value.

    C
    It sets the identity field value to 1.

    D
    All of these

    Note: Not available
    1. Report

  2. Question: Which of the following statements are true about FILESTREAM storage in SQL Server 2008?

    A
    Transact-SQL can be used to SELECT, INSERT, UPDATE, DELETE FILESTREAM data.

    B
    The size of the stored data is limited to 2 GB.

    C
    You cannot take backup of a database without the FILESTREAM data.

    D
    FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher.

    Note: Not available
    1. Report

  3. Question: Which of the following permissions are required to create a view in SQL Server 2008?

    A
    CREATE VIEW permission in database

    B
    ALTER permission on schema

    C
    CONTROL permission on object

    D
    All of these

    Note: Not available
    1. Report

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

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

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

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

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

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

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