Menu
Home / CSE MCQs / SQL Server MCQs :: SQL Server Laying Foundation

CSE MCQs :: SQL Server MCQs

SQL Server MCQs - SQL Server Security
SQL Server MCQs - SQL Server Specifications
SQL Server MCQs - SQL Server Beyond Relational
SQL Server MCQs - SQL Server Data Connectivity
SQL Server MCQs - SQL Server Laying Foundation
SQL Server MCQs - SQL Server Manipulating Data
SQL Server MCQs - SQL Server Monitoring, Auditing
SQL Server MCQs - SQL Server Business Intelligence
SQL Server MCQs - SQL Server Developing with SQL Server
SQL Server MCQs - SQL Server Enterprise Data Management
SQL Server MCQs - SQL Server Performance Tuning,Optimization
  1. Which of the following is not a aggregate function ?
    2. A.
    Avg
    B.
    Sum
    C.
    With
    D.
    Min

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which of the following SQL clauses is used to DELETE tuples from a database table ?
    3. A.
    DELETE
    B.
    REMOVE
    C.
    DROP
    D.
    CLEAR

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. With SQL, how can you return the number of not null records in the "Persons table ?
    4. A.
    SELECT COUNT() FROM Persons
    B.
    SELECT COLUMNS() FROM Persons
    C.
    SELECT COLUMNS(*) FROM Persons
    D.
    SELECT COUNT(*) FROM Persons

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. SQL query to find the temperature in increasing order of all cities.
    5. A.
    SELECT city FROM weather ORDER BY temperature
    B.
    SELECT city, temperature FROM weather
    C.
    SELECT city, temperature FROM weather ORDER BY temperature
    D.
    SELECT city, temperature FROM weather ORDER BY city

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Which of the following is not a mathematical function ?
    6. A.
    ATN2
    B.
    POWER
    C.
    PI
    D.
    CEIL

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. A column of type __________ may contain rows of different data types.
    7. A.
    ntext
    B.
    date
    C.
    smallmoney
    D.
    sql_variant

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. LocalDB was introduced in which of the following versions of SQL Server ?
    8. A.
    2012
    B.
    2008
    C.
    2014
    D.
    2008 R2

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the following is one of the basic approaches for joining tables?
    9. A.
    Subqueries
    B.
    Union Join
    C.
    Natural join
    D.
    All of the Mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Template Explorer is used to manage ____________
    10. A.
    T-SQL scripts
    B.
    Registered Servers
    C.
    Properties
    D.
    Query design

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. Ctrl+K+K shortcut refers to ___________
    11. A.
    Refresh IntelliSense
    B.
    Add or remove a bookmark
    C.
    Enable all bookmarks
    D.
    Move to the next bookmark

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers