T-SQL Online Test

Candidates Assessed

14267+

Organizations Served

145+

Our T SQL online test is the ideal pre-hire assessment for tech recruiters & hiring managers to assess a candidate’s programming skills objectively before interview. This test is specially designed to hire T-SQL developer and helped our customers reduce hiring costs by 40%.

Test Summary

T-SQL test helps you to screen the candidates who possess traits as follows:

T-SQL query development skills for building queries, data mining and analytics
Ability to work with SQL scripts, stored procedures
Strong knowledge of concepts like nested cursors, loops, and common table expressions
Knowledge of using PIVOT & UNPIVOT to convert table expression to other

Assessing candidates with a T-SQL online test is secure and reliable. 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, image & video 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 (AI-based Pseudo-Coding Platform), Coding Simulators, True or False Questions, etc.

Test Duration: 20 minutes

No. of Questions: 10

Level of Expertise: Senior

Useful for hiring

T-SQL Developer
Sr. T-SQL Developer
SQL Developer- T SQL
SQL Server Database Developer

Topics Covered

Nested Cursors

Our T-SQL online test helps recruiters to assess candidates' knowledge about nested cursors which is a loop in another loop in a SQL server

Top Filters

This test assesses candidates' ability of working with TOP filters which is a commonly used construct in SQL

JOIN

iMocha’s T-SQL pre-employment test evaluates candidates understanding about JOIN clause which combine and retrieve data from two or more tables

MERGE

This test helps recruiters to evaluate candidate’s ability to use MERGE statement to INSERT new record or UPDATE existing records within same statement

Pivot Table

Our test evaluates candidates' understanding about using pivot table to summarize data where rows data is converted into column data to get simplified view of table

Loops

This test helps recruiters and hiring managers to evaluate candidate’s knowledge about Loops statements in SQL which is a series of statements executed repeatedly

Common Table Expressions

Our T-SQL assessment test evaluates candidates' knowledge about common table expressions (CTE) which is a named temporary result set that can referenced within statements such as SELECT, INSERT, UPDATE, or DELETE

Sample Questions

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

Question types:

Multiple Option

Topic:

GROUP BY

Difficulty:

Easy

Q 1. Which SQL statement is correct?

SELECT customername, Count(customername)
FROM orders;

SELECT customername, Count(customername)
FROM orders
GROUP BY customername;

SELECT customername, Count(customername)
FROM orders
ORDER BY customername;

Question types:

Multiple Option

Topic:

TRANSACTION

Difficulty:

Medium

Q 2. What will be the result of running this script without any additional operations?

Script:

USE loxf;goBEGIN
DISTRIBUTED TRANSACTION;DELETE candidate
FROM   a local instance.DELETE datatbasename.dbo.tbluserprofile
WHERE  userindex = 13;DELETE candidate
FROM   remote instance.DELETE remoteserver.datatbasename.dbo.tbluserprofile
WHERE  userindex = 13;COMMIT TRANSACTION;go

Candidates will be deleted from the remote instance first.

Candidates will be deleted from the local instance and then from a remote distance.

Error: Could not find server 'RemoteServer'.

You can customize this test by

Setting difficulty level of test

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

Combining multiple skills into one test

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

Adding your own questions to the test

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

Requesting a tailor-made test

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

Related Skills

Database, SQL Fundamentals Test

Trusted By

“Siemens needed an employee review metric that was based on pure data, making it simpler for the hiring managers to evaluate their team. At the same time, we wanted the employees to be able to show case their domain knowledge and skills without the fear of any biases affecting their review process.”