Microsoft SQL Server DBA Online Test - 2012

Candidates Assessed

14567+

Organizations Served

126+

SQL Server DBA online test is the most preferred pre-hire test for recruiters and hiring managers to assess SQL skills of the candidates before interview. Our test is useful for hiring SQL Server Database Administrator/ SQL DBA, SQL Server DBA Consultant, and SQL Server DBA Specialist and reduces hiring time by 45% & Increase interview-to-selection ratio by 62% 
 

About Microsoft SQL Server DBA Online Test - 2012

Microsoft SQL Server is an RDBMS developed by Microsoft. SQL Server DBA is mainly responsible for the administration, installation, and maintenance of SQL Server Database. Database administrators look into the security and performance of the data.

SQL Server DBA online test helps tech recruiters & hiring managers to quantify a candidate’s SQL Server administration skills before the interview. SQL DBA online test is designed by experienced Subject Matter Experts (SME) to evaluate and hire SQL Server DBA as per the industry standards.

Are you a jobseeker looking to sharpen your skills?

Test Summary

SQL Server DBA assessment helps to screen the candidates who possess traits as follows: 

  • Fundamental knowledge of SQL Server
  • Expertise in SQL Server database security and troubleshooting
  • Ability to configure and maintain database servers & processes
  • Proficiency in backup & recovery
  • Ability to install & configure new SQL servers

With role-based access control, you can now maintain security within your account by providing access to each user based on their established role. Features like window violation and webcam proctoring help detect cheating during the test.

This test may contain MCQs (Multiple Choice Questions), MAQs (Multiple Answer Questions), Fill in the Blanks, Whiteboard Questions, Audio / Video Questions, AI-LogicBox (Pseudo-Coding Platform), Coding Simulators, True or False Questions, etc.  

Test Duration: 20 minutes

No. of Questions: 10

Level of Expertise: Entry/Mid/Senior

Useful for hiring

  • SQL Server Database Administrator/ SQL DBA
  • SQL Server DBA Consultant
  • SQL Server DBA Specialist

Topics Covered


right arrow

lang="EN-US">Create Cluster

right arrow
Permissions

Our test assesses applicant’s knowledge about SQL secure permissions which can provide and revoke access to securable 

right arrow
Transact-SQL statement

This test evaluates candidate’s understanding about T-SQL which is mainly used for writing entire program of block function procedure 

right arrow
Configuration

This test assesses a candidate’s ability to configure Microsoft SQL server 

right arrow
Transact Log Management

Our test evaluates candidate’s understanding about Transact Log which is used to maintain a sequential record of all changes made to the database 

right arrow
Concepts – Auditing

iMocha’s SQL DBA online test reduces candidate’s ability to audit the SQL server which monitors a group of actions 

right arrow
Concepts – Replication

Our assessment checks candidate’s knowledge about data replication which provides data availability when fault occurs to the server 

right arrow
Stored procedure

This test gauges candidate’s understanding about stored procedure where a block of code can be reused repeatedly 

Sample Questions

Choose from our 100,000+ question library or add your own questions to make powerful custom tests

Question types:

Multiple Answer

Topic:

Stored Procedure

Difficulty:

Hard


Q 1. You manage 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.
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 types:

Multiple Option

Topic:

Concepts - Replication

Difficulty:

Medium


Q 2. You manage 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?
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

Sample Report

View Full Report . . .

Skill wise performance report by iMocha

Hire job-fit candidates using this test now

You can customize this test by

difficulty level
Setting difficulty level of test      

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.                       

multiple skills
Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.                                              

adding own skill
Adding your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.                       

tailor made test
Requesting a tailor-made test                  

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

Trusted By

Vipin Sharma, Mobile Programming
gartner Logo

“Thanks to Customer Success Team of iMocha, they have shared the best practices of quick test creation & also helped us in training all our recruiters for various functionalities of the tool. Now my team of 25 recruiters has adopted this measure & it has done wonders for our clients.”

Vipin Sharma, Mobile Programming

capgemini logo
coupa logo
ericsson logo
cognizant logo
nice logo
wipro logo

Start hiring job-fit candidates using this assessment