Databases - Upwork
 

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

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

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

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

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

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

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

  8. Question: Which of the following is the new sample database in the SQL SERVER 2005?

    A
    Northwind

    B
    pubs

    C
    AdventureWorks

    D
    master

    E
    tempdb

    Note: Not available
    1. Report

  9. Question: Which of the following SQL queries correctly selects the rows from the table "employees" that have NULL value in the "salary" column?

    A
    SELECT * FROM employees WHERE salary=null

    B
    SELECT * FROM employees WHERE salary equals null

    C
    SELECT * FROM employees WHERE salary is null

    D
    SELECT * FROM employees WHERE salary contains null

    Note: Not available
    1. Report

  10. Question: Which level of data abstraction describes the data that is stored in the database and their corresponding relationships?

    A
    View Level

    B
    Procedural Level

    C
    Physical Level

    D
    Logical Level

    E
    Conceptual Level

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