Intelligent MS SQL Server 2014 Assessment Test

10 Questions | Total Attempts: 197

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

      ===