MS SQL Server 2005
 

  1. Question: Which data type in the SQL SERVER 2005 converts itself into the type of data that is inserted into it?

    A
    real

    B
    rowversion

    C
    type_var

    D
    sql_variant

    E
    monetary

    Note: Not available
    1. Report

  2. Question: Which of the following is not a logical operator?

    A
    between

    B
    any

    C
    some

    D
    like

    E
    with

    Note: Not available
    1. Report

  3. Question: Which of the following methods is used to backup the Transaction log on to a secondary database in order to backup and recover data in a synchronized manner?

    A
    Using the backup of Transaction log (ldf) file

    B
    Taking Backup using flat files

    C
    Using Log Shipping

    D
    Taking Database Snapshot of Transaction log

    Note: Not available
    1. Report

  4. Question: Which of the following statements is/are wrong?

    A
    Both Primary key and Unique key enforce uniqueness

    B
    Primary keys create a clustered index by default

    C
    Both Primary key and Unique key don't allow NULL values

    D
    Unique keys create a non-clustered index by default

    E
    It is possible to have more than one Primary key in a table

    Note: Not available
    1. Report

  5. Question: Which of the following is a database object?

    A
    Tables

    B
    Stored Procedures

    C
    Indexes

    D
    UDF(User Defined Functions)

    E
    All of these

    Note: Not available
    1. Report

  6. Question: Which of the following statements is correct?

    A
    Modifications made in a table will be faster if the number of indexes is more

    B
    Modifications made in a table will be slower if the number of indexes is more

    C
    The number of indexes does not affect the modification process of a table

    Note: Not available
    1. Report
First678Last
/8
Copyright © 2025. Powered by Intellect Software Ltd