Search test library by skills or roles
⌘ K

About the test:

The T SQL Online Test 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.

Covered skills:

  • Nested Cursors
  • JOIN
  • Top Filters
  • MERGE
See all covered skills

9 reasons why
9 reasons why

Adaface T SQL Online Test is the most accurate way to shortlist T-SQL Developers



Reason #1

Tests for on-the-job skills

Transact SQL(T SQL)测试有助于招聘人员和招聘经理从简历中确定合格的候选人,并有助于做出客观的招聘决策。它减少了采访太多候选人的管理开销,并通过过滤不合格的候选人节省了时间。

ADAFACE TRASSACT-SQL(T-SQL)评估筛选典型技能招聘人员在T-SQL开发人员中寻找的候选者:

  • 具有T-SQL的经验包括动态SQL
  • SSIS/SSRS开发的经验
  • SQL Server的开发经验
  • 能够与数据库团队合作最佳实践和遵守编码标准

招聘人员和招聘经理可以使用此评估产生的见解,以确定T-SQL开发人员角色的最佳候选人。反交换功能使您能够在线进行评估。 Transact SQL(T SQL)在线测试非常适合帮助招聘人员确定哪些候选人具有在工作中表现出色的技能。

Reason #2

No trick questions

Traditional assessment tools use trick questions and puzzles for the screening, which creates a lot of frustration among candidates about having to go through irrelevant screening assessments.

The main reason we started Adaface is that traditional pre-employment assessment platforms are not a fair way for companies to evaluate candidates. At Adaface, our mission is to help companies find great candidates by assessing on-the-job skills required for a role.

Why we started Adaface ->
Reason #3

Non-googleable questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

这些只是我们库中有10,000多个问题的一个小样本。关于此的实际问题 T SQL Online Test 将是不可行的.

🧐 Question

Medium

MS SQL: enterpriseDB, GROUP BY
Solve
The following T-SQL statements are run on enterpriseDB database:
 image
uamMembers with MemberPaid as 1 implies that the member payment is complete. We want to find number of paid users for each uamGroup. (If a uamGroup does not have any paid members, we want to have 0 as paid members count). Of the following T-SQL statements, what should we run to achieve this?
 image

Medium

MS SQL: Most recurring errors
Solve
Check out following MS SQL tables:
 image
We have a status monitoring page to display most recurring errors for each user. Here's the T-SQL statement to achieve this:
 image
How would you fill the empty blocks to finish the T-SQL statement from following options?
 image

Medium

Multi Select
Solve
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Easy

Select & IN
Solve
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

Medium

With, AVG & SUM
Solve
Consider the following SQL table:
 image
How many tuples does the following query return?
 image
🧐 Question🔧 Skill

Medium

MS SQL: enterpriseDB, GROUP BY
4 mins
MS SQL
Solve

Medium

MS SQL: Most recurring errors
4 mins
MS SQL
Solve

Medium

Multi Select
2 mins
SQL
Solve

Easy

Select & IN
3 mins
SQL
Solve

Medium

With, AVG & SUM
2 mins
SQL
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
MS SQL: enterpriseDB, GROUP BY
MS SQL
Medium4 mins
Solve
MS SQL: Most recurring errors
MS SQL
Medium4 mins
Solve
Multi Select
SQL
Medium2 mins
Solve
Select & IN
SQL
Easy3 mins
Solve
With, AVG & SUM
SQL
Medium2 mins
Solve
Reason #4

1200+ customers in 75 countries

Brandon

借助Adaface,我们能够优化我们的初始筛查过程超过75%,从而为招聘经理和我们的人才获取团队提供了宝贵的时间!


Brandon Lee, 人的负责人, Love, Bonito

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment T SQL Online Test in your hiring process is that it is an elimination tool, not a selection tool. In other words: you want to use the test to eliminate the candidates who do poorly on the test, not to select the candidates who come out at the top. While they are super valuable, pre-employment tests do not paint the entire picture of a candidate’s abilities, knowledge, and motivations. Multiple easy questions are more predictive of a candidate's ability than fewer hard questions. Harder questions are often "trick" based questions, which do not provide any meaningful signal about the candidate's skillset.

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the T SQL Online Test from your dashboard by entering their email address.

Public link: You can create a public link for each test that you can share with candidates.

API or integrations: You can invite candidates directly from your ATS by using our pre-built integrations with popular ATS systems or building a custom integration with your in-house ATS.

Reason #7

Detailed scorecards & comparative results

Reason #8

High completion rate

Adaface tests are conversational, low-stress, and take just 25-40 mins to complete.

This is why Adaface has the highest test-completion rate (86%), which is more than 2x better than traditional assessments.

Reason #9

Advanced Proctoring


关于T-SQL开发人员角色

T-SQL或Transact SQL是Microsoft SQL Server使用的查询语言。它可以协助完成任务,例如从单行获取数据,添加新行并检索几行。 SQL Server将其用作程序语言。

####典型的T-SQL开发人员职责包括:

  • 设计和创建表,视图,触发器,分区,复杂的存储过程,功能,索引和其他数据库对象
  • 使用DTS/SSIS进口数据,批量插入,BCP和DTS/SSIS软件包支持数据提取和转换
  • 配置数据库系统的自动主动和反应性监视
  • 分析数据库
  • 记录开发和工作流程需求的过程和过程

What roles can I use the T SQL Online Test for?

  • T-SQL Developer
  • Sr. T-SQL Developer

What topics are covered in the T SQL Online Test?

交易结构性查询语言
专有语言
数据库引擎
截短
本地变量
子查询
动态查询
服务器集成服务
数据审核
报告生成
价值列表
最佳
加入类型
t字符串功能
Offset-fetch滤波器
不可交易的交易

目录存储程序

sp_pkeys
设置语句
身份列
Singapore government logo

招聘经理认为,通过小组访谈中他们提出的技术问题,他们能够分辨哪些候选人的得分更好,并且与未得分的人有区别。他们是 非常满意 候选人的质量被Adaface筛选入围。


85%
reduction in screening time

常见问题解答

我可以将多个技能结合在一起,为一个自定义评估吗?

是的,一点没错。自定义评估是根据您的职位描述进行的,并将包括有关您指定的所有必备技能的问题。

您是否有任何反交换或策略功能?

我们具有以下反交易功能:

  • 不可解决的问题
  • IP策略
  • Web Protoring
  • 网络摄像头Proctoring
  • 窃检测
  • 安全浏览器

阅读有关[Proctoring功能](https://www.adaface.com/proctoring)的更多信息。

如何解释考试成绩?

要记住的主要问题是评估是消除工具,而不是选择工具。优化了技能评估,以帮助您消除在技术上没有资格担任该角色的候选人,它没有进行优化以帮助您找到该角色的最佳候选人。因此,使用评估的理想方法是确定阈值分数(通常为55%,我们为您提供基准测试),并邀请所有在下一轮面试中得分高于门槛的候选人。

我可以使用该测试的经验水平?

每个ADAFACE评估都是为您的职位描述/理想候选角色定制的(我们的主题专家将从我们的10000多个问题的图书馆中选择正确的问题)。可以为任何经验级别定制此评估。

每个候选人都会得到同样的问题吗?

是的,这使您比较候选人变得容易得多。 MCQ问题的选项和问题顺序是随机的。我们有[抗欺骗/策略](https://www.adaface.com/proctoring)功能。在我们的企业计划中,我们还可以选择使用类似难度级别的问题创建多个版本的相同评估。

我是候选人。我可以尝试练习测试吗?

不,不幸的是,我们目前不支持实践测试。但是,您可以使用我们的[示例问题](https://www.adaface.com/questions)进行练习。

使用此测试的成本是多少?

您可以查看我们的[定价计划](https://www.adaface.com/pricing/)。

我可以免费试用吗?

我刚刚搬到了一个付费计划。我如何要求自定义评估?

Join 1200+ companies in 75+ countries.
Try the most candidate friendly skills assessment tool today.
Ready to use the Adaface T SQL Online Test?
Ready to use the Adaface T SQL Online Test?
与我们聊天
40 min tests.
No trick questions.
Accurate shortlisting.
Terms Privacy Trust Guide

🌎 Pick your language

English Norsk Dansk Deutsche Nederlands Svenska Français Español Chinese (简体中文) Italiano Japanese (日本語) Polskie Português Russian (русский)
Ada
Ada
● Online
Previous
Score: NA
Next
✖️