Search Adaface test library by skills or roles
⌘ K

SQL Server Online Test

The Microsoft SQL Server (2012 Administrator) is preferred by recruiters to assess on-the-job skills of candidates before an interview. It reduces technical screening time by 80% by enabling employers to identify qualified candidates.

Customized Based On:

  • Experience/ difficulty level
  • Multiple skills in 1 assessment
  • Job description/ role requirements

Covered 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)
See full list
Singapore government logo

The hiring managers felt that through the technical questions that they asked during the panel interviews, they were able to tell which candidates had better scores, and differentiated with those who did not score as well. They are highly satisfied with the quality of candidates shortlisted with the Adaface screening.


Human Resources Manager

Singapore Government

85%
reduction in screening time

Sample Adaface Microsoft SQL Server (2012 Administrator) Questions

These are just a small sample from our library of 10,000+ questions. The actual questions on this Microsoft SQL Server (2012 Administrator) will be non-googleable.

🧐 Question🔧 Skill💪 Difficulty⌛ Time
Merge data sources
Teylor Swift is a developer at your company and is setting up a data flow transformation to merge 2 data sources. 1 source contains item data and the other source contains data regarding the company which made the item.

The 2 data sources use SQL Server and have a 3-character CompanyCode column. Both data sources contain an ORDER BY clause to sort the data by CompanyCode in ascending order.

Teylor wants to make sure that the Merge Join transformation works without additional transformations. What would you recommend?
A: Change the ORDER BY clause on the item source to order by ItemName.
B: Set the appropriate SortKeyPosition properties on the data sources.
C: Set the IsSorted property on both data sources.
D: Change the Merge Join transformation to a Merge transformation.

Options:

  • A B
  • A C
  • A D
  • B C
  • B D
  • C D
  • A
  • B
  • C
  • D
SQL ServerMedium2 min
Multi Select
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Options:

  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
SQLMedium2 min
Select & IN
Consider the following SQL table:
 image
Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
 image

Options:

  • A
  • B
  • C
  • D
  • E
SQLEasy3 min
With, AVG & SUM
Consider the following SQL table:
 image
How many tuples does the following query return?
 image

Options:

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
SQLMedium2 min

How to use the Adaface Microsoft SQL Server (2012 Administrator)

Start screening candidates within minutes with the ready-to-go Microsoft SQL Server (2012 Administrator)

1. Choose the most appropriate test for your role

2. Start inviting candidates to complete the assessment

3. Receive real time notifications and shortlist the best candidates

Customize the Adaface Microsoft SQL Server (2012 Administrator) according to your job description

1. Get a custom assessment from our library of 500+ skills within 48 hours

2. Start inviting candidates to complete the assesment

3. Receive real time notifications and shortlist the best candidates

Adaface Microsoft SQL Server (2012 Administrator) is trusted by enterprises worldwide

amazon
PayPal
Morgan Stanley
Adidas
SG Government
Neilsen
UCLA
Ernst and Young
Microsoft
WeWork
Bosch
Optimum Solutions
SAP
Doubtnut
Deloitte
HCL
FusionCharts
United Nations
Sokrati
Love Bonito
ZiMetrics
MTM

About the Adaface Microsoft SQL Server (2012 Administrator)

Evaluate technical and coding skills with Adaface skills assessment platform powered by an intelligent chatbot.

Topics:

Windows Mode, Mixed Mode

Two Authentication Modes
SQL Profiler
Recursive Stored Procedure
Local and Global Temporary Tables
CHECK Constraint
Sub Query
SQL Server Agent
Scheduled Tasks
COALESCE
FLOOR Function
Locks
SIGN Function

Used to execute a batch of SQL code when insert or update or delete commands are executed against a table

Trigger
IDENTITY Column
Bulkcopy
UNION
UNION ALL
Stored Procedure
Dynamic SQL
Collation
SET NOCOUNT ON/OFF Statement

SQL Server creates magic tables to hold the values during the DML operations

Magic Tables
SUBSTR
CHARINDEX
FOR Clause
Varchar and Nvarchar Types
GETDATE and SYSDATETIME

Used to extract sample of rows randomly that are all necessary for the application

TABLESAMPLE

Used to store XML documents in the SQL Server database

XML Datatype

Change Data Capture

CDC

An attack by malicious users in which malicious code can be inserted into strings that can be passed to an instance of SQL server for parsing and execution

SQL Injection
Filtered Index

Recommended Roles:

SQL Server DBA
MS SQL Server Database Admin

Why You Should Use This MS SQL Server Test

The MS SQL Server Online Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates.

The Adaface MS SQL Server Online Test screens candidates for the typical skills recruiters look for MS SQL Server DBA/Developer roles:

  • Knowledge of Performance Tuning and Optimization (PTO), including the use of native monitoring and troubleshooting tools
  • Knowledge of backup, restore, and recovery models
  • Understanding of SQL Server High Availability (HA) and Disaster Recovery (DR) options
  • Previous experience with Windows servers, including Active Directory
  • Excellent written and oral communication skills
  • The ability to arrange and plan work on one's own
  • The ability to multitask and transition between activities and teams efficiently
  • MCTS, MCITP, and/or MVP certifications are advantageous

The insights generated from this assessment can be used by recruiters and hiring managers to identify the best candidates for MS SQL Server DBA/Developer roles. Anti-cheating features enable you to be comfortable with conducting assessments online. The MS SQL Server Online Test is ideal for helping recruiters identify which candidates have the skills to do well on the job.

About MS SQL Server DBA/Developer Roles

Microsoft SQL Server is a relational database management system that Microsoft created. It is a database server, a software product that stores and retrieves data as required by other software programmes. It may operate on the same computer or another computer over a network.

MS SQL Server database administrators manage all aspects of Microsoft SQL Server management, including installation and patching, database creation, and permissions that allow users to access the databases.

However, they are primarily accountable for data security and performance standards. They frequently serve as internal consultants on how to utilise SQL Server successfully. It is essential because if a database goes down or data is lost, the firm and its customers suffer quickly.

Typical MS SQL Server DBA/Developer responsibilities include:

  • Manage SQL Server databases across the product lifecycle, from development to mission-critical production systems
  • Set up and manage database servers and procedures, including system health and performance monitoring, to assure high performance, availability, and security
  • Use data modelling approaches to guarantee that development and implementation support activities fulfil integration and performance goals
  • Analyze, diagnose, and repair errors independently in real-time, offering end-to-end problem resolution
  • Improve and automate routine operations, keep track of concerns, and document changes
  • Assist developers with complex query tuning and schema refining
  • Support critical production systems 24 hours a day, seven days a week
  • After hours, perform planned maintenance and assist in release deployment operations
  • Share domain and technical skills by mentoring and cross-training other peers and team members

Distribution Of Test Scores

The actual score distribution will vary based on your candidate pipeline quality, but you should typically expect ~20% of the candidates to do well on Adaface assessments.

The score distribution for our assessments follow the normal curve. This is a good sign- standardized tests like SAT and GRE follow the normal distribution (bell curve).

Status quo assessments typically have the exact opposite of the bell curve (too many candidates getting close to 0, too many candidates getting close to 100 and too few candidates in the middle). This is typically because they focus on theoretical questions or trick questions, which are very binary in nature- either you know the trick/ theory or you don’t.

How Adaface Is Different

Adaface conversational assessments are reflective of on-the-job skills and see an 86% completion rate as compared to ~50% for traditional assessment platforms.

OLD WAY

TRADITIONAL TESTS

Theoretical questions/ puzzles

Feels like a test

One-size-fits-all assessments

😞
HIRE IN
Weeks/Months

NEW WAY

ADAFACE ASSESSMENTS

Questions for on-the-job skills

Conversational

Customized
assessments

😀️
HIRE IN
Days

FAQs

What is a custom assessment?

Every role is different and requires a custom assessment to identify top candidates efficiently. Adaface subject matter experts understand your job description/ role requirements and pick the most relevant questions from our library of 10000+ questions to create a technical assessment that helps you find the qualified candidates in your candidate pipeline quickly. All custom assessments are set up based on the job description, role requirements, must-have skills, experience level and salary range within a maximum of 48 hours and you will get an email notification once it goes live.

Check out a sample assessment here (no credit card required).

Can I combine multiple skills into one custom assessment?

Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify.

How is Adaface different from other assessment tools?

We believe that status quo tech assessment platforms are not a fair way for companies to evaluate engineers because they focus on trick questions/ puzzles/ niche algorithms. We started Adaface to help companies find great engineers by assessing on-the-job skills required for a role. Read more about why we started Adaface.

Here's what's different with Adaface:

  • High quality non-googleable questions that test for on-the-job skills as opposed to theoretical knowledge.
  • A friendly conversational assessment with a chatbot, instead of sending a "test" to a candidate. This translates to a higher completion rate. Adaface assessments (86% candidate completion rate), as opposed to traditional tests (40-50% candidate completion rate)
  • Customized assessments for 700+ skills at different experience levels.

Do you have any anti-cheating or proctoring features in place?

We have the following anti-cheating features in place:

  • Web proctoring
  • Webcam proctoring
  • Plagairism detection
  • Non-googleable questions
  • Secure browser

Read more about the proctoring features.

How do I interpret test scores?

The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

What experience level can I use this test for?

Each Adaface assessment is customized to your job description/ ideal candidate persona (our subject matter experts will pick the right questions for your assessment from our library of 10000+ questions). This assessment can be customized for any experience level.

Does every candidate get the same questions?

Yes, it makes it much easier for you to compare candidates. Options for MCQ questions and the order of questions are randomized. We have anti-cheating/ proctoring features in place. In our enterprise plan, we also have the option to create multiple versions of the same assessment with questions of similar difficulty levels.

I'm a candidate. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

What is the cost of using this test?

You can check out our pricing plans.

Can I get a free trial?

The platform is completely self-serve, so here's one way to proceed:

  • You can sign up for free to get a feel for how it works.
  • The free trial includes one sample assessment (Java/ JavaScript) that you will find in your dashboard when you sign up. You can use it to review the quality of questions, and the candidate experience of a conversational test on Adaface.
  • To review the quality of questions, you can also review our public questions for 50+ skills here.
  • Once you're convinced that you want to try it out with real assessments and candidates, you can pick a plan according to your requirements.

I just moved to a paid plan. How can I request a custom assessment?

Here is a quick guide on how to request a custom assessment on Adaface.

With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!


Brandon Lee, Head of People, Love, Bonito

hashtag image heart icon Brandon
Join 1200+ companies in 75+ countries.
Try the most candidate friendly skills assessment tool today.
Have any questions about the Adaface Microsoft SQL Server (2012 Administrator)?
Have any questions about the Adaface Microsoft SQL Server (2012 Administrator)?
Chat with us ✨
Terms Privacy Trust Guide