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

CSE MCQs :: SQL Server MCQs

  1. Which of the following is not a aggregate function ?
  2. A.
    Avg
    B.
    Sum
    C.
    With
    D.
    Min

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

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

  7. SQL query to find the temperature in increasing order of all cities.
  8. 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

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

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

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

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

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

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