MS SQL Server 2012 (administrator) Assessment Test

10 Questions

Settings
Please wait...
MS SQL Server 2012 (administrator) Assessment Test

As an MS SQL Server database administrator, your role is to be efficient in the datacenter to the cloud, Platform as a Service, and Linux as you administer databases in SQL Server on a number of platforms.


Questions and Answers
  • 1. 
    How can you trace traffic hitting an SQL server? 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. 

      Merge

    • B. 

      Snapshot

    • C. 

      Transaction

    • D. 

      Transformation

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

      Merge

    • B. 

      Snapshot

    • C. 

      Transaction

    • D. 

      Transformation

  • 4. 
    How can you schedule jobs to run at 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 subquery not linked with an outer query

    • B. 

      An outer query linked with a nested subquery

    • C. 

      A nested subquery linked to an outer query

    • D. 

      An outer query not linked to a nested subquery

  • 6. 
    SQL supports__ types of authentication modes
    • A. 

      2

    • B. 

      3

    • C. 

      4

    • D. 

      5

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

      Multiple rows

    • B. 

      Multiple columns

    • C. 

      Single

    • D. 

      Double rows

  • 8. 
    Which of these functions is function is used to 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