T-SQL Online Test

Candidates Assessed

14267+

Organisations 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%. 

About T-SQL Online Test

Transact-SQL (T-SQL) is a programming language that is Microsoft's and Sybase's proprietary extension to SQL. It is the language that is developed for querying, altering, defining relational databases and using declarative statements. Transact-SQL has additional features and expands on the SQL standards including procedural programming and data processing, transaction control and error handling. 
 
T-SQL online test helps tech recruiters and hiring managers to assess candidate's T-SQL programming skills. iMocha’s Transact SQL (T SQL) test is created & validated by experienced Subject Matter Experts (SME) to assess & hire T SQL developer as per the industry standards. 

Are you a jobseeker looking to sharpen your skills?

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


right arrow
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  

right arrow
Top Filters

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

right arrow
JOIN

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

right arrow
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  

right arrow
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  

right arrow
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 

right arrow
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 of the following SQL statements 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 remote instance first.
 
Candidates will be deleted from local instance then same from a remote distance.
 
Error: Could not find server 'RemoteServer'.
 

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

Pedro Furtado, Capacity Manager, Altran-Portugal
gartner Logo

“Finding quality talent is a challenge more so when you consider the sheer number of resumes we get each year. To top this, the time we spent on our recruitment process was humongous. iMocha helped us to cut down on our candidate filtration time by 40 %, making it our preferred assessment tool.”

Pedro Furtado, Capacity Manager, Altran-Portugal

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

Start hiring job-fit candidates using this assessment