Intelligent MS SQL Server 2014 Assessment Test

10 Questions

Settings
Please wait...
Assessment Test Quizzes & Trivia

.


Questions and Answers
  • 1. 
    Hose can you trace traffic hitting an SQL? it can be traced using
    • A. 

      SQL profiler

    • B. 

      SQL replication

    • C. 

      SQL agent

    • D. 

      Update statistics

  • 2. 
    Which of these is not a type of SQL Replication?
    • A. 

      Transaction

    • B. 

      Transformation

    • C. 

      Snapshot

    • D. 

      Merge

  • 3. 
    Which of these Replication uses a snapshot to seed the application?
    • A. 

      Merge

    • B. 

      Transformation

    • C. 

      Transaction

    • D. 

      Snapshot

  • 4. 
    How can you schedule jobs to run at a set time or when a specific event occurs?
    • A. 

      By using the SQL agent

    • B. 

      By using the SQL scheduler

    • C. 

      By using checkpoints

    • D. 

      By calling update statistics

  • 5. 
    What is a correlated sub-query?
    • A. 

      A nested query not linked with an outer query

    • B. 

      An outer query linked with a nested query

    • C. 

      A nested sub query linked with an outer query

    • D. 

      An outer query not linked to a nested query

  • 6. 
    SQL supports___types of authentication modes
    • A. 

      4

    • B. 

      5

    • C. 

      2

    • D. 

      7

  • 7. 
    What type of sub query can you use to return multiple rows?
    • A. 

      Single

    • B. 

      Multiple rows

    • C. 

      Multiple columns

    • D. 

      Double rows

  • 8. 
    Which of these functions is used round up a non-integer value to the previous least integer?
    • A. 

      UNION ALL

    • B. 

      FLOOR

    • C. 

      IDENTITY

    • D. 

      UNION

  • 9. 
    Which of these is not a type of trigger?
    • A. 

      Error

    • B. 

      Insert

    • C. 

      Delete

    • D. 

      Update

  • 10. 
    What do we use collation for?
    • A. 

      To change a table

    • B. 

      To specify order in a table

    • C. 

      To collect data from a table

    • D. 

      To create rows in a table