.Net Technology - Upwork
 

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

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

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

  4. Question: Which of the following commands is used to run a Transact-SQL script file by using sqlcmd?

    A
    sqlcmd -S myServer\instanceName -i C:\newScript.sql

    B
    sqlcmd -S instanceName -o C:\newScript.sql

    C
    sqlcmd -S myServer\instanceName -r C:\newScript.sql

    D
    sqlcmd -S instanceName -i C:\newScript.sql

    Note: Not available
    1. Report

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

    A
    5 digits

    B
    6 digits

    C
    7 digits

    D
    10 digits

    Note: Not available
    1. Report

  6. Question: Which of the following permissions is required to drop a stored procedure in SQL Server 2008?

    A
    SELECT permission on the schema

    B
    ALTER permission on the schema

    C
    CONTROL permission on the procedure

    D
    ALTER permission on the schema and CONTROL permission on the procedure

    Note: Not available
    1. Report

  7. Question: The login timeout when you try to connect to a server must be a number between ______.

    A
    0 and 66020

    B
    1 and 65530

    C
    0 and 65534

    D
    1 and 65535

    Note: Not available
    1. Report

  8. Question: In which of the following statements can TOP clause be used in SQL Server 2008?

    A
    Only SELECT

    B
    Only SELECT and INSERT

    C
    Only SELECT, INSERT, UPDATE, DELETE

    D
    Only SELECT, INSERT, UPDATE, MERGE, DELETE

    Note: Not available
    1. Report

  9. Question: Which of the following default passwords is used by sqlcmd if -P option is used at the end of the command prompt without a password?

    A
    0000

    B
    NULL

    C
    1234

    D
    None of these

    Note: Not available
    1. Report

  10. Question: Which of the following namespaces is used to manage the audit configuration programmatically in SQL Server 2008?

    A
    Microsoft.SqlServer.Management.Smo

    B
    Microsoft.SqlServer.Server

    C
    Microsoft.sqlserver.management.common

    D
    Microsoft.sqlserver.connectioninfo

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