Search test library by skills or roles
⌘ K

About the test:

Java SQL测试评估了候选者使用Java编程语言使用关系数据库的能力。该测试评估了SQL查询,数据库设计和Java编程的基本至高级概念的候选人。评估的关键技能和主题包括了解关系数据库,SQL查询,Java数据库连接(JDBC),数据建模和使用Java的数据操作。该测试还包括一个用于测试动手编程技能的编码问题。

Covered skills:

  • Java基础知识
  • 例外
  • 数据库设计
  • Java编码
  • 面向对象的编程
  • SQL基础知识
  • 查询和操纵数据

9 reasons why
9 reasons why

Adaface Java & SQL Test is the most accurate way to shortlist Java开发人员s



Reason #1

Tests for on-the-job skills

The Java & SQL Online Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

  • 展示了熟练的Java基础知识
  • 有效地应用面向对象的编程概念
  • 有效处理异常和错误
  • 显示对SQL基础知识的深刻理解
  • 展示数据库设计原理的知识
  • 能够查询和操纵SQL数据库中的数据
  • 胜任Java编码
Reason #2

No trick questions

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.

View sample questions

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.

How we design questions

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

🧐 Question

Easy

Custom Exception
Exception Handling
Custom Exceptions
Solve
What does the following code output?
 image

Hard

Holding References
Solve
What does the following Java code output?
 image

Medium

Abstract Interface
OOPs
Interfaces
Solve
Given following interface:
 image
Which of these are correct classes?
 image

Medium

Garbage Collection
Garbage Collection
Solve
After which line is "bs" object, created on Line 4, eligible for garbage collection?
 image

Hard

Static Init Blocks
OOPs
Solve
What does the following code output?
 image
1) G A B E D H
2) G B A D E H
3) G B A D E H C F
4) C F G A B E D H
5) C F G B A D E H
6) G C F A B E D H
7) G C F B A D E H

Medium

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

Medium

nth highest sales
Nested queries
User Defined Functions
Solve
Consider the following SQL table:
 image
Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
 image

Medium

Select & IN
Nested queries
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

Sorting Ubers
Nested queries
Join
Comparison operators
Solve
Consider the following SQL table:
 image
What will be the first two tuples resulting from the following SQL command?
 image

Hard

With, AVG & SUM
MAX() MIN()
Aggregate functions
Solve
Consider the following SQL table:
 image
How many tuples does the following query return?
 image

Easy

Registration Queue
Logic
Queues
Solve
We want to register students for the next semester. All students have a receipt which shows the amount pending for the previous semester. A positive amount (or zero) represents that the student has paid extra fees, and a negative amount represents that they have pending fees to be paid. The students are in a queue for the registration. We want to arrange the students in a way such that the students who have a positive amount on the receipt get registered first as compared to the students who have a negative amount. We are given a queue in the form of an array containing the pending amount.
For example, if the initial queue is [20, 70, -40, 30, -10], then the final queue will be [20, 70, 30, -40, -10]. Note that the sequence of students should not be changed while arranging them unless required to meet the condition.
⚠️⚠️⚠️ Note:
- The first line of the input is the length of the array. The second line contains all the elements of the array.
- The input is already parsed into an array of "strings" and passed to a function. You will need to convert string to integer/number type inside the function.
- You need to "print" the final result (not return it) to pass the test cases.

For the example discussed above, the input will be:
5
20 70 -40 30 -10

Your code needs to print the following to the standard output:
20 70 30 -40 -10

Medium

Visitors Count
Strings
Logic
Solve
A manager hires a staff member to keep a record of the number of men, women, and children visiting the museum daily. The staff will note W if any women visit, M for men, and C for children. You need to write code that takes the string that represents the visits and prints the count of men, woman and children. The sequencing should be in decreasing order. 
Example:

Input:
WWMMWWCCC

Expected Output: 
4W3C2M

Explanation: 
‘W’ has the highest count, then ‘C’, then ‘M’. 
⚠️⚠️⚠️ Note:
- The input is already parsed and passed to a function.
- You need to "print" the final result (not return it) to pass the test cases.
- If the input is- “MMW”, then the expected output is "2M1W" since there is no ‘C’.
- If any of them have the same count, the output should follow this order - M, W, C.
🧐 Question🔧 Skill

Easy

Custom Exception
Exception Handling
Custom Exceptions

2 mins

Java
Solve

Hard

Holding References

2 mins

Java
Solve

Medium

Abstract Interface
OOPs
Interfaces

2 mins

Java
Solve

Medium

Garbage Collection
Garbage Collection

2 mins

Java
Solve

Hard

Static Init Blocks
OOPs

2 mins

Java
Solve

Medium

Multi Select
JOIN
GROUP BY

2 mins

SQL
Solve

Medium

nth highest sales
Nested queries
User Defined Functions

3 mins

SQL
Solve

Medium

Select & IN
Nested queries

3 mins

SQL
Solve

Medium

Sorting Ubers
Nested queries
Join
Comparison operators

3 mins

SQL
Solve

Hard

With, AVG & SUM
MAX() MIN()
Aggregate functions

2 mins

SQL
Solve

Easy

Registration Queue
Logic
Queues

30 mins

Coding
Solve

Medium

Visitors Count
Strings
Logic

30 mins

Coding
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Custom Exception
Exception Handling
Custom Exceptions
Java
Easy2 mins
Solve
Holding References
Java
Hard2 mins
Solve
Abstract Interface
OOPs
Interfaces
Java
Medium2 mins
Solve
Garbage Collection
Garbage Collection
Java
Medium2 mins
Solve
Static Init Blocks
OOPs
Java
Hard2 mins
Solve
Multi Select
JOIN
GROUP BY
SQL
Medium2 mins
Solve
nth highest sales
Nested queries
User Defined Functions
SQL
Medium3 mins
Solve
Select & IN
Nested queries
SQL
Medium3 mins
Solve
Sorting Ubers
Nested queries
Join
Comparison operators
SQL
Medium3 mins
Solve
With, AVG & SUM
MAX() MIN()
Aggregate functions
SQL
Hard2 mins
Solve
Registration Queue
Logic
Queues
Coding
Easy30 minsSolve
Visitors Count
Strings
Logic
Coding
Medium30 minsSolve
Reason #4

1200+ customers in 75 countries

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 Java&SQL测试 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.

Science behind Adaface tests
Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Java&SQL测试 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.

invite candidates
Reason #7

Detailed scorecards & benchmarks

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.

test completion rate
Reason #9

Advanced Proctoring


Learn more

About the Java & SQL Assessment Test

Why you should use Pre-employment Java & SQL Online Test?

The Java&SQL测试 makes use of scenario-based questions to test for on-the-job skills as opposed to theoretical knowledge, ensuring that candidates who do well on this screening test have the relavant skills. The questions are designed to covered following on-the-job aspects:

  • 理解Java基础知识
  • 精通面​​向对象的编程概念
  • 有效处理异常的能力
  • SQL基础知识的强大知识
  • 数据库设计专业知识
  • 熟练查询和操纵数据
  • 擅长Java编码
  • 设计模式的经验
  • 精通多线程和并发
  • servlet和JSP的知识

Once the test is sent to a candidate, the candidate receives a link in email to take the test. For each candidate, you will receive a detailed report with skills breakdown and benchmarks to shortlist the top candidates from your pool.

What topics are covered in the Java & SQL Online Test?

  • 面向对象的编程

    面向对象的编程(OOP)很重要。是一个编程范式,可以通过使用对象,类和继承来组织和管理代码。该技能评估了个人在Java中应用OOP原则的能力,包括封装,多态性和抽象。衡量此技能至关重要,因为OOP广泛用于Java开发并促进模块化和可重复使用的代码。

  • 例外

    例外情况是指对不可预见的事件的处理,这些事件可能会破坏正常流动程序执行。该技能涉及了解各种类型的异常,例如检查和未检查的异常,并使用Try-Catch块适当地处理它们。衡量此技能可确保候选人可以有效处理错误方案并编写可靠且可靠的Java代码。

  • SQL Basics

    SQL基础知识涵盖了结构化查询语言的基础概念和语法(SQL )。其中包括创建和操纵数据库,定义表和查询数据等主题。衡量此技能是必不可少的,因为SQL是一种与关系数据库进行交互的标准语言,并且对SQL基础知识的强烈了解对于使用数据存储和检索至关重要。

  • 数据库设计

    数据库设计涉及创建数据库系统的结构和组织。此技能包括设计数据库模式,建立表之间的关系以及优化数据库性能。衡量此技能很重要,因为一个精心设计的数据库可以增强数据完整性,降低冗余并提高整体系统效率。

  • Java编码

    Java编码测试候选人的能力编写正确有效的Java代码以解决特定问题或实施所需的功能。该技能涵盖了各个方面,包括代码结构,算法思维和遵守最佳实践。衡量这项技能对于评估候选人的动手编程能力及其在使用Java编程语言实施解决方案方面的能力。

  • Full list of covered topics

    The actual topics of the questions in the final test will depend on your job description and requirements. However, here's a list of topics you can expect the questions for Java&SQL测试 to be based on.

    Java变量
    Java数据类型
    Java控制流
    Java操作员
    Java数组
    Java课
    Java继承
    Java多态性
    Java封装
    Java异常处理
    SQL数据类型
    SQL表创建
    SQL查询
    SQL加入
    SQL聚合
    SQL约束
    SQL子征服
    SQL索引
    SQL视图
    SQL交易
    数据库归一化
    关系数据库设计
    数据库模式
    酸性
    查询优化
    实体关系(ER)图
    数据建模
    主键
    外国钥匙
    数据库索引
    数据库视图
    数据库触发器
    Java文件I/O
    Java异常类型
    例外处理最佳实践
    Java试用
    检查与未选中的例外
    Java自定义异常
    SQL插入语句
    SQL Update语句
    SQL删除语句
    SQL选择语句
    SQL过滤
    SQL排序
    SQL聚合
    SQL分组
    爪哇面向对象的设计
    Java继承与构图
    Java抽象
    SQL归一化
    SQL成分
    SQL索引策略
    Java编码约定
    Java调试
    Java代码优化
    SQL数据操纵
    SQL数据定义
    SQL数据控制

What roles can I use the Java & SQL Online Test for?

  • Java开发人员
  • 软件工程师Java
  • 后端Java开发人员
  • SQL开发人员
  • Java完整堆栈开发人员
  • Java应用程序开发人员
  • SQL数据库开发人员

How is the Java & SQL Online Test customized for senior candidates?

For intermediate/ experienced candidates, we customize the assessment questions to include advanced topics and increase the difficulty level of the questions. This might include adding questions on topics like

  • 具有性能调整方面的专业知识
  • 优化SQL查询的能力
  • 高级数据库概念的经验
  • 擅长应用程序测试和调试
  • 冬眠框架的知识
  • 对春季框架的强烈理解
  • 精通RESTFUL Web服务
  • 微服务体系结构的经验
  • 能够开发可扩展和稳健应用的能力
  • 敏捷软件开发实践方面的专业知识
  • 对设计原理和模式的强大知识

The coding question for experienced candidates will be of a higher difficulty level to evaluate more hands-on experience.

Singapore government logo

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


85%
减少筛查时间

Java & SQL Hiring Test 常见问题解答

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

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

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

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

  • 不可解决的问题
  • 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/)。

我可以免费试用吗?

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

customers across world
Join 1200+ companies in 75+ countries.
立即尝试最候选的友好技能评估工具。
g2 badges
Ready to use the Adaface Java&SQL测试?
Ready to use the Adaface Java&SQL测试?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
术语 隐私 信任指南

🌎选择您的语言

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