T-SQL Test to Assess T SQL Developer

Start hiring job-fit candidates using this assessment

Trusted by leading brands worldwide

“We are a tutoring agency, wherein the crux of our business lies in the quality of the tutors we hire. Hence it is imperative that our hiring is top notch. We were impressed by the caliber, depth, and breadth of the assessments provided by Interview Mocha. With Interview Mocha, we have found a great assessment tool for our hiring requirements.”

Megan Akhras, Co-founder & director, J'Excelle, Canada

Start inviting candidates in next 2 minutes

About T SQL Online Test

Transact-SQL (T-SQL) is a programming language which 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 recruiters and hiring managers to assess candidate's T SQL programming skills. Interview Mocha’s Transact SQL (T SQL) assessment test is created & validated by experienced subject matter experts (SMEs) to assess & hire T SQL developer as per industry standards.

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

1. T-SQL query development skills for building queries, data mining and analytics
2. Ability to work with SQL scripts, stored procedures
3. Strong knowledge of concepts like nested cursors, loops, common table expressions

Online transact SQL skill test will evaluate the candidate’s practical knowledge and will identify whether the candidate is ready to be employed. Transact SQL (T SQL) assessment test has an online proctoring feature to detect misconduct during the test.

This T SQL Online Test is useful for hiring

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

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;

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'.

T SQL Online Test

Topics covered

You can customize this test by

Setting difficulty level of test

Combining multiple skills into one test

Adding your own questions to the test

Requesting a tailor-made test

Start hiring job-fit candidates using this assessment

Trusted by leading brands worldwide

Megan Akhras, Co-founder & director, J'Excelle, Canada

Start inviting candidates in next 2 minutes

About T SQL Online Test

This T SQL Online Test is useful for hiring

Start hiring job-fit candidates using this assessment

Trusted by leading brands worldwide

Megan Akhras, Co-founder & director, J'Excelle, Canada

Start inviting candidates in next 2 minutes

Related Skills

About T SQL Online Test

This T SQL Online Test is useful for hiring