Knowledge of SQL Server 2008
 

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

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

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

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

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

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

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

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

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

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