Intelligent MS SQL Server 2014 Assessment Test

10 Questions

Settings
Please wait...
Intelligent MS SQL Server 2014 Assessment Test

Powerful, reliable, free, rich, and lightweight are words that describe Microsoft SQL Server 2014, which is a data management system used for delivering data stores for websites and desktop apps. Take this quiz to find out more.


Questions and Answers
  • 1. 
    How many authentication modes are there in an SQL server?
    • A. 

      7

    • B. 

      6

    • C. 

      2

    • D. 

      3

  • 2. 
    Which of these allows an admin to monitor events in an SQL server?
    • A. 

      SQL profiler

    • B. 

      Local table

    • C. 

      Sub query

    • D. 

      SQL server agent

  • 3. 
    What is the maximum level a recursive stored procedure can reach?
    • A. 

      40

    • B. 

      200

    • C. 

      32

    • D. 

      48

  • 4. 
    What happens to local temporary tables when connection is closed? They are...
    • A. 

      Transferred

    • B. 

      Deleted

    • C. 

      Converted to numbers

    • D. 

      Change to rows

  • 5. 
    What type of table is created by ## commands?
    • A. 

      Global temporary table

    • B. 

      Local temporary table

    • C. 

      Column table

    • D. 

      Row table

  • 6. 
    Which of these can be applied to a column to limit the data that can be placed in it?
    • A. 

      Server agent

    • B. 

      Check constraint

    • C. 

      Column sub query

    • D. 

      Coalesce

  • 7. 
    Which of these cannot be checked by the sign function?
    • A. 

      Positive

    • B. 

      Negative

    • C. 

      Zero

    • D. 

      Alphabet

  • 8. 
    All of these are types of trigger except...
    • A. 

      Update

    • B. 

      Instead of

    • C. 

      Insert

    • D. 

      Pull

  • 9. 
    Which of these tools can be used to copy a large amount of data in an SQL?
    • A. 

      Copy

    • B. 

      Large copy

    • C. 

      Bulk copy

    • D. 

      Cut

  • 10. 
    Which of these is used to compare only strings with strings?
    • A. 

      ==

    • B. 

      =

    • C. 

      ====

    • D. 

      ===