Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Microsoft SQL Server 2012 DBA Test

Topics Covered

  • Transactional and relational Database
  • Configurations
  • Database & Database Objects
  • Installation
  • Synchronization
  • Transaction Logs
  • Database Monitoring & Maintenance
  • Backup & Recovery
  • SQL Server Database Security & Troubleshooting
  • Storage Area Network (SAN)

Useful for hiring

  • SQL Server DBA
  • MS SQL Server Database Admin
  • SQL Server Database Administrator
  • SQL Server DBA Consultant

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed with Interview Mocha's comprehensive IT skill test batteries and their ability to provide tailor-made assessments quickly. The results we got from Interview Mocha exceeded our expectations, employees found the tests quick, fun, and a benchmark of their knowledge."

Ajay Garg, Siemens,
Associate Manager
Question

You administer a Microsoft SQL Server 2012 database. The database has a table named Customers owned by User A and another table named Orders owned by User B. You also have a stored procedure named GetCustomerOrderInfo owned by User B. GetCustomerOrderInfo selects data from both tables. You create a new user named User C. You need to ensure that User C can call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum required permissions to User C. Which permission or permissions should you assign to User C?

Note: There can be multiple correct answers to this question.

Answer
    • The Select permission on Customers
       

    • The Execute permission on GetCustomerOrderInfo
       

    • The Take Ownership permission on Customers
       

    • The Control permission on GetCustomerOrderInfo
       

    • The Take Ownership permission on Orders
       

    • The Select permission on Orders
       

Question

You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors. You need to reduce the occurrence of these timeout errors. What should you do?

Answer
    • Set the Merge agent on the problem subscribers to use the slow link agent profile
       

    • Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication
       

    • Change the Merge agent on the problem subscribers to run continuously.
       

    • Set the Remote Connection Timeout on the Publisher to 0.
       

Question

You administer a Microsoft SQL Server 2012 database. You provide temporary security admin access to User1 to the database server. You need to know if User1 adds logins to security admin. Which server-level audit action group should you use?

Answer
    • SERVER_STATE_CHANGE_GROUP
       

    • SERVER_PRINCIPAL_IMPERSONATION_GROUP
       

    • SUCCESSFUL_LOGIN_GROUP
       

    • SERVER_ROLE_MEMBER_CHANGE_GROUP
       

Test details:

This test enables employers and recruiters to evaluate skills and job readiness of candidates. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.

Duration: 20 minutes
Questions: 20 minutes

Test description:

SQL Server DBA online test helps Hiring Managers & Recruiters to judge the candidate’s knowledge of Microsoft SQL Server 2012 Administrator before an interview.

An SQL Server DBA is mainly responsible for the administration, installation, and maintenance of SQL Server Database. Microsoft SQL Server administrator Test is specially designed to check the database and administration skills of a Microsoft SQL 2012 Admin – as per Industry Standards.


The test contains questions on the following topics:
 

  • Transactional and relational Database

  • Configurations

  • Database & Database Objects

  • Installation

  • Synchronization

  • Transaction Logs

  • Database Monitoring & Maintenance

  • Backup & Recovery

  • SQL Server Database Security & Troubleshooting

  • Storage Area Network (SAN)


MS SQL server 2012 database test is designed by our subject matter experts to analyze one’s understanding of this discipline. Using powerful reporting, you can have a detailed analysis of the test results to help you make a better hiring decision and predict the candidate’s performance.

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO