MS SQL Server 2005
 

  1. Question: What exactly is the Full-Text Catalog?

    A
    The Full-Text catalog is an index for searching specific keywords

    B
    The Full-Text catalog is a file which contains full-text indexes

    C
    The Full-Text catalog is basically an inbuilt function for checking the validation of a text

    D
    The Full-Text catalog is a system trigger for checking text validation

    Note: Not available
    1. Report

  2. Question: The commands GRANT and REVOKE are examples of :

    A
    DDL (Data Definition Language)

    B
    DML (Data Manipulation Language)

    C
    TCL (Transaction Control Language)

    D
    DCL (Data Control Language)

    Note: Not available
    1. Report

  3. Question: We are creating Stored Procedure in Database and using "sp_" prefix in its name. Which of the following statements is correct in accordance with the performance of the Stored Procedure execution?

    A
    The prefix will speed up the execution as it is in cache and will always get executed with high priority

    B
    The prefix will slow down the execution as the prefix is reserved for system stored procedures

    C
    The performance will not be affected as "sp_" is just a prefix for a stored procedure

    D
    The prefix will speed up the execution as prefix "sp_" is used for stored procedures by default

    Note: Not available
    1. Report

  4. Question: Which of the following operators will be evaluated first in the following statement? Select (salary+40^2*30/5) from employees

    A
    +

    B
    *

    C
    /

    D
    ^

    Note: Not available
    1. Report

  5. Question: Which of the following is not a type of Database backup in the SQL SERVER 2005?

    A
    Complete backup

    B
    Differential backup

    C
    Transaction Log backup

    D
    Partial backup

    E
    File(s) and Filegroup(s) backup

    Note: Not available
    1. Report

  6. Question: Which clause will be used to extract data from Tables A and B having a similar structure but no relation between themselves?

    A
    Join

    B
    Group By

    C
    Order By

    D
    Union All

    E
    Where

    Note: Not available
    1. Report

  7. Question: You have a database named 'marketnikkie', the backup of which is stored at 'D:\marketnikkie.bak' location on your server. Due to some electric fluctuations, the database gets corrupt. Which of the following is the correct query to restore your database?

    A
    RESTORE DATABASE marketnikkie FROM DISK = 'D:\marketnikkie.bak'

    B
    RESTORE DATABASE FROM DISK = 'D:\marketnikkie.bak'

    C
    RESTORE DATABASE marketnikkie FROM = 'D:\marketnikkie.bak'

    D
    RESTORE marketnikkie FROM DISK = 'D:\marketnikkie.bak'

    E
    RESTORE DATABASE marketnikkie.mdf FROM DISK = 'D:\marketnikkie.bak'

    Note: Not available
    1. Report

  8. Question: Which among the following are the new datatypes introduced in the SQL Server 2005?

    A
    varchar (max)

    B
    varbinary (max)

    C
    nvarchar (max)

    D
    nvarbinary (max)

    E
    image

    F
    uniqueidentifier

    G
    xml

    Note: Not available
    1. Report

  9. Question: Which of the following is not a Method call of .NET class for Assemblies in the SQL Server?

    A
    Init

    B
    Accumulate

    C
    Aggregate

    D
    Merge

    E
    Terminate

    Note: Not available
    1. Report

  10. Question: You have two tables emp_1 and emp_2, having the following data: Table emp_1 Name Date Robert 1/5/2008 John 1/6/2008 Michael 1/7/2008 Rachael 1/10/2008 Joey 1/10/2008 Table emp_2 Name Date Lewis 1/05/2008 David 1/07/2008 George 1/11/2008 Jerry 1/12/2008 Monica 1/12/2008 The following query is run in the Query Analyzer: SELECT Date FROM emp_1 EXCEPT SELECT Date FROM emp_2 What will be the result of the query?

    A
    1/6/2008, 1/10/2008, 1/11/2008, 1/12/2008

    B
    1/6/2008, 1/10/2008, 1/10/2008

    C
    1/6/2008, 1/10/2008, 1/11/2008, 1/12/2008, 1/12/2008

    D
    1/6/2008, 1/10/2008

    E
    The query will give an error as EXCEPT is only concerned with varchar values

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