MS SQL Server 2012 (Administrator) Assessment Test

10 Questions | Total Attempts: 219

SettingsSettingsSettings
MS SQL Server 2012 (Administrator) Assessment Test - Quiz

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

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.