Clock
Test duration:
20
min
Notes
No. of questions:
10
Tie
Level of experience:
Senior

T-SQL Test

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

11004
+
Candidates
Assessed
131
+
Organizations Served
Fujitsu
Paypal
Capgemini
Deloitte
Coupa
UN Logo
Vanguard
EY Logo
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 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 candidates' T-SQL programming skills. iMocha's Transact SQL (T SQL) test is created and validated by experienced subject matter experts (SMEs) to assess and hire T SQL developers as per industry standards.

Use iMocha's assessment to hire skill fit, remove bias, and save money!
Book a demo
How it works

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 and UNPIVOT to convert table expressions 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 and image and 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
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
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Heading

This is some text inside of a div block.
Shuffle

Nested Cursors

Our T-SQL online test helps recruiters to assess candidates&

Top Filters

This test assesses candidates&
Shuffle

Shuffle

Shuffle

Shuffle

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

Question types :

Multiple Option

Topic:

Difficulty:

Hard


Q 1. You have been asked to train « Naive Bayes model for spam detection dataset

Using Python command, what wil you add in the given code at XXXX to deciore, it and train your modal for the given dataset?

import numpy os np

X= nporroyll 3. 2b[1 21 [2.21.[3,21)
Y= nporray(fi.a,a.1))

XXXX

from skinamnaive_bayas import

Gaussianna

otf = Gaussianne()

ceataie(x ¥)

from skinamnaive_bayas import

Gaussianna

otf = Gaussianne()

ceataie(x ¥)

from skinamnaive_bayas import

Gaussianna

otf = Gaussianne()

ceataie(x ¥)

from skinamnaive_bayas import

Gaussianna

otf = Gaussianne()

ceataie(x ¥)

Question types :

Multiple Option

Topic:

Machine teaming

Difficulty:

Hard


Q 1. Q2 Lets assume that you have 6 Pandas DataFrome(af) in the below tole.

Index Code Open High
0 AAPL 19877 70074
1 AAPL 19877 70074
2 AAPL 19877 70074
3 AAPL 19877 70074
4 AAPL 19877 70074

When the following commend is executed, what hoppens to the DatoFrome?

df= defiinat()
Y= nporray(fi.a,a.1))

Index Code Open High
0 AAPL 19877 70074
1 AAPL 19877 70074
2 AAPL 19877 70074
3 AAPL 19877 70074
4 AAPL 19877 70074
Index Code Open High
0 AAPL 19877 70074
1 AAPL 19877 70074
2 AAPL 19877 70074
3 AAPL 19877 70074
4 AAPL 19877 70074
it gives an error becouse of the third row which has on empty string.
None of these

Question types :

Multiple Option

Topic:

GROUP BY

Difficulty:

Easy

Question:

Which of the following SQL statements is correct?


Options

  • <font color="blue">SELECT</font>&nbsp;<font color="maroon">customername</font><font color="silver">,</font>&nbsp;<font color="fuchsia"><i>Count</i></font><font color="maroon">(</font><font color="maroon">customername</font><font color="maroon">)</font>&nbsp;<br /><font color="blue">FROM</font>&nbsp;<font color="maroon">orders</font>;<br />&nbsp;
  • <font color="blue">SELECT</font>&nbsp;<font color="maroon">customername</font><font color="silver">,</font>&nbsp;<font color="fuchsia"><i>Count</i></font><font color="maroon">(</font><font color="maroon">customername</font><font color="maroon">)</font>&nbsp;<br /><font color="blue">FROM</font>&nbsp;<font color="maroon">orders</font>&nbsp;<br /><font color="blue">GROUP</font>&nbsp;<font color="blue">BY</font>&nbsp;<font color="maroon">customername;</font><br />&nbsp;
  • <font color="blue">SELECT</font>&nbsp;<font color="maroon">customername</font><font color="silver">,</font>&nbsp;<font color="fuchsia"><i>Count</i></font><font color="maroon">(</font><font color="maroon">customername</font><font color="maroon">)</font>&nbsp;<br /><font color="blue">FROM</font>&nbsp;<font color="maroon">orders</font>&nbsp;<br /><font color="blue">ORDER</font>&nbsp;<font color="blue">BY</font>&nbsp;<font color="maroon">customername;</font><br />&nbsp;
A helicopter view of the employee's progress
View Full Report
Test Report
Hire job-fit candidates using this test now!
Schedule a demo
You can customize this test by
IMocha Logo

Setting the difficulty level of the test

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

Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment and assess multiple skills together.
Add New

Adding your own
questions to the test

Add, edit, or bulk upload your coding, MCQ, and whiteboard questions.
Edit

Requesting a tailor-made test

Receive a tailored assessment created by our subject matter experts to ensure adequate screening.

Build your dream team

Book a demo
ADP
Now my team of 25 recruiters has adopted this measure and it has done wonders for our clients. Thanks to the Customer Success Team of iMocha. They have shared the best practices of quick test creation and also helped us in training all our recruiters for various functionalities of the tool.
Client

Vipin Sharma,

Mobile Programming
FAQ
What is Data Science?
Down Arrow Circle

.NET Design Pattern test helps recruiters to evaluate candidates' ability to work on GOF Decorator Design Pattern to solve recurring design problems and design flexible and reusable object-oriented software

Why use iMocha’s online data science test?
Down Arrow Circle

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

What are the key skills that recruiter should look for while hiring a Data Scientist?
Down Arrow Circle

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

What are few interview questions that recruiter/hiring manager should ask while hiring a data scientist?
Down Arrow Circle

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

How do you assess the data scientists?
Down Arrow Circle

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

No items found.