Home / CSE MCQs / SQL Server MCQs :: SQL Server Manipulating Data

CSE MCQs :: SQL Server MCQs

  1. Which of the following constraint does not enforce uniqueness ?
  2. A.
    UNIQUE
    B.
    Primary key
    C.
    Foreign key
    D.
    None of the mentioned

  3. Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?
  4. A.
    Salary, dept_id
    B.
    Employee
    C.
    Salary
    D.
    All the field of employee relation

  5. The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.
  6. A.
    Create table
    B.
    Create temporary table
    C.
    Create view
    D.
    Create label view

  7. Which of the following is the simplest ranking function ?
  8. A.
    RANK
    B.
    NTILE
    C.
    ROW_NUMBER
    D.
    None of the mentioned

  9. Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use :
  10. A.
    Limit 10
    B.
    Upto 10
    C.
    Only 10
    D.
    Max 10

  11. Which of the following is not the function of client ?
  12. A.
    Compile queries
    B.
    Query optimization
    C.
    Receive queries
    D.
    Result formatting and presentation

  13. Windowing function was added in which of the following versions of SQL Server ?
  14. A.
    2003
    B.
    2005
    C.
    2008
    D.
    None of the mentioned

  15. Which of the the function is not a ranking window function ?
  16. A.
    RANK
    B.
    NTILE
    C.
    ROW_NUMBER
    D.
    None of the mentioned

  17. Purpose of foreign key constraint in SQL Server is :
  18. A.
    FOREIGN KEY constraints identify and enforce the relationships between tables
    B.
    A foreign key in one table points to a candidate key in another table
    C.
    You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value
    D.
    None of the mentioned