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

"The best part of Interview Mocha is they have topic wise questions available. The skill wise extensive reports and advanced analytics lets us measure & benchmark the proficiency level of employees in that particular skill."

Cheryl Tolkinen, Securian, USA,
Learning & Development 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

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