Search test library by skills or roles
⌘ K

About the test:

Python,Django&SQL测试使用基于方案的MCQ来评估候选者在Python编程语言,Django Web Framework和SQL数据库方面的熟练程度。该测试评估了候选人对主题的理解,例如对象关联映射,数据库模型,查询组,视图,模板,中间件和SQL查询。评估了他们使用这些技术来开发具有高级功能的Web应用程序的能力,以及他们在编写优化且安全的SQL查询中用于数据库交互的能力。

Covered skills:

  • Python基本面
  • 桌子上的CRUD操作
  • Django框架基础知识
  • Django模板
  • SQL加入和索引
  • 数据结构
  • 错误和异常处理
  • Django模型和视图
  • SQL CRUD操作
  • Python编程

9 reasons why
9 reasons why

Adaface Python, Django & SQL Test is the most accurate way to shortlist Python/ Django开发人员s



Reason #1

Tests for on-the-job skills

The Python, Django & 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:

  • 能够使用最佳实践和惯例编写Python代码
  • 熟悉Python数据结构以进行有效的数据操纵
  • 熟练在SQL表上执行CRUD操作
  • 处理Python中错误和例外的能力
  • 了解用于构建Web应用程序的Django框架基础知识
  • Django模型的知识和数据库交互的视图
  • 熟练使用Django模板呈现动态内容
  • 能够在SQL数据库上执行CRUD操作
  • SQL Joins和索引的知识以进行有效的数据检索
  • Python的编程能力
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多个问题的一个小样本。关于此的实际问题 Python,Django和SQL测试 将是不可行的.

🧐 Question

Medium

ZeroDivisionError and IndexError
Exceptions
Solve
What will the following Python code output?
 image

Medium

Session
File Handling
Dictionary
Solve
 image
The function high_sess should compute the highest number of events per session of each user in the database by reading a comma-separated value input file of session data. The result should be returned from the function as a dictionary. The first column of each line in the input file is expected to contain the user’s name represented as a string. The second column is expected to contain an integer representing the events in a session. Here is an example input file:
Tony,10
Stark,12
Black,25
Your program should ignore a non-conforming line like this one.
Stark,3
Widow,6
Widow,14
The resulting return value for this file should be the following dictionary: { 'Stark':12, 'Black':25, 'Tony':10, 'Widow':14 }
What should replace the CODE TO FILL line to complete the function?
 image

Medium

Max Code
Arrays
Solve
Below are code lines to create a Python function. Ignoring indentation, what lines should be used and in what order for the following function to be complete:
 image

Medium

Recursive Function
Recursion
Dictionary
Lists
Solve
Consider the following Python code:
 image
In the above code, recursive_search is a function that takes a dictionary (data) and a target key (target) as arguments. It searches for the target key within the dictionary, which could potentially have nested dictionaries and lists as values, and returns the value associated with the target key. If the target key is not found, it returns None.

nested_dict is a dictionary that contains multiple levels of nested dictionaries and lists. The recursive_search function is then called with nested_dict as the data and 'target_key' as the target.

What will the output be after executing the above code?

Medium

Stacking problem
Stack
Linkedlist
Solve
What does the below function ‘fun’ does?
 image
A: Sum of digits of the number passed to fun.
B: Number of digits of the number passed to fun.
C: 0 if the number passed to fun is divisible by 10. 1 otherwise.
D: Sum of all digits number passed to fun except for the last digit.

Easy

URL Dispatcher
Routes
Solve
Review the following sample Django URL.conf:
 image
Pick the correct statements if settings.APPEND_SLASH=False:

A: A request to /books/2015/04/ would match the third entry in the list. Django would call the function views.month_books(request, year=2015, month=4).
B: A request to /books/2015/04/ would match the second entry in the list. Django would call the function views.year_books(request, year=2015).

C: A request to /books/2023/ will match the first entry in the list. Django would call the the function views.custom_newyear_2023(request).
D: A request to /books/2023/ would match the second entry in the list. Django would call the function views.year_books(request, year=2023).

E: /books/2022 would not match any of these patterns, because each pattern requires that the URL end with a slash.
F: A request to /books/2022 would match the second entry in the list. Django would call the function views.year_books(request, year=2022).

Medium

External Bank Transfer
Database Transactions
Solve
Review the following Django code for a banking application:
 image
The code needs to debit an account with the provided amount and deposit the amount in an external entity. Here’s how the code is broken:

1) First, the amount is debited from the account by creating a new row in BalanceLine table.
2) Next, a new row is created in the DB in ExternalTransfer table and a new id (used as unique reference) is created for the transfer.
3) An external 3rd party API call is made using the new id created in step 2.

The function transfer_to_other_bank is called as shown below:
 image
Pick the correct statements:

A: If post_transfer_emails() raises an exception, the database transactions that happened in transfer_to_other_bank are not rolled back since they are listed in a separate atomic transaction.
B: If post_transfer_emails() raises an exception, the database transactions (new rows in ExternalTransfer and BalanceLine tables) are rolled back. The banking_api call is called again with a null reference.
C: If post_transfer_emails() raises an exception, the database transactions are rolled back but the banking_api is not called again.
D: If post_transfer_emails() raises an exception, the banking_api is called again with rollback=True. If the response is success, then the database transactions are rolled back. If the response is failure, the database transactions are committed.

Medium

Query retired people
Solve
An HRTech startup has the following Django code:
 image
We want a QuerySet with all Person objects where retired == True and age != 45. Which of the following do you think we should use?
 image

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

Medium

ZeroDivisionError and IndexError
Exceptions

2 mins

Python
Solve

Medium

Session
File Handling
Dictionary

2 mins

Python
Solve

Medium

Max Code
Arrays

2 mins

Python
Solve

Medium

Recursive Function
Recursion
Dictionary
Lists

3 mins

Python
Solve

Medium

Stacking problem
Stack
Linkedlist

4 mins

Python
Solve

Easy

URL Dispatcher
Routes

2 mins

Django
Solve

Medium

External Bank Transfer
Database Transactions

3 mins

Django
Solve

Medium

Query retired people

2 mins

Django
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
ZeroDivisionError and IndexError
Exceptions
Python
Medium2 mins
Solve
Session
File Handling
Dictionary
Python
Medium2 mins
Solve
Max Code
Arrays
Python
Medium2 mins
Solve
Recursive Function
Recursion
Dictionary
Lists
Python
Medium3 mins
Solve
Stacking problem
Stack
Linkedlist
Python
Medium4 mins
Solve
URL Dispatcher
Routes
Django
Easy2 mins
Solve
External Bank Transfer
Database Transactions
Django
Medium3 mins
Solve
Query retired people
Django
Medium2 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 Python,Django和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 Python,Django和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 Python, Django & SQL Assessment Test

Why you should use Pre-employment Python, Django & SQL Online Test?

The Python,Django和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:

  • python语法和基本面
  • Python中的数据结构
  • 处理异常和错误
  • SQL表上的CRUD操作
  • 了解SQL加入和索引
  • 基本的Django框架概念
  • Django模型 - 创建和修改数据库表
  • Django视图 - 处理HTTP请求和响应
  • 使用Django模板
  • 执行SQL CRUD操作

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 Python, Django & SQL Online Test?

  • 数据结构

    数据结构是指该方式的方式。数据在计算机程序中组织,存储和访问。在测试中测量了该技能,以评估候选人在使用不同数据结构(例如列表,词典,集合和元组)上的知识和熟练程度,以有效地解决编程问题。

  • 对桌子上的CRUD操作

    crud操作(创建,读取,更新,删除)在表上涉及使用SQL查询在关系数据库中处理数据。在测试中测量了此技能,以评估候选人使用数据库,执行基本数据库操作并确保数据完整性的能力。

  • 错误和异常处理

    错误和异常处理处理在程序执行中识别,捕获和管理错误或意外事件的过程。在测试中测量了该技能,以评估候选人在编写可靠代码方面的熟练程度,该代码可以优雅地处理错误并防止程序崩溃。

  • django框架基础知识

    django是高级 - 级别Python Web框架,使开发人员能够构建可靠且可扩展的Web应用程序。在测试中测量了该技能,以评估候选人对Django框架的基本概念,组件和工作流程的理解。

  • django模型和视图

    django模型,视图是不可或缺的Django框架的一部分。模型定义了Django应用程序中的数据结构和关系,而视图处理渲染模板背后的逻辑和处理用户请求。在测试中测量了该技能,以评估候选人在Django中设计和实施模型和视图的熟练程度。

  • django模板

    django模板用于定义结构,布局和。在Django应用程序中的网页介绍。在测试中测量了该技能,以评估候选人使用Django的模板系统创建动态和用户友好的Web接口的能力。

  • sql crud操作

    <p> sql crud操作涉及涉及执行,执行创建,执行创建,,在使用SQL查询的关系数据库中存储的数据上读取,更新和删除操作。在测试中测量了这项技能,以评估候选人在使用SQL的查询,操纵和管理数据方面的熟练程度。

  • SQL JOIN和索引

    sql Joins用于组合多个行的行基于相关列的表,而索引用于通过创建有效的数据结构来优化查询性能。在测试中测量了该技能,以评估候选人对高级SQL概念的理解及其编写复杂数据库查询的能力。

  • Python编程

    Python编程是指整体知识和专业知识在使用Python语言来解决现实世界中的问题时。在测试中测量了这项技能,以评估候选人在编写Python代码,实施算法和运用最佳实践来开发高质量软件方面的熟练程度。

  • 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 Python,Django和SQL测试 to be based on.

    Python语法
    变量和数据类型
    有条件的语句
    循环结构
    功能和模块化编程
    异常处理
    文件处理
    列表和元组
    字典和集合
    类和对象
    继承和多态性
    文件输入/输出
    连接到数据库
    创建表和模式
    插入和更新数据
    检索和查询数据
    删除数据和删除表
    主键和外键
    索引和性能优化
    错误类型和处理技术
    模型视图控制器(MVC)体系结构
    URL路由
    查看功能和基于班级的视图
    模型和数据库迁移
    形式和形式处理
    模板语法和标签
    模板继承和上下文变量
    查询组和数据库查询
    对象相关映射(ORM)
    一对一,一对多和多对多的关系
    过滤和订购数据
    汇总和注释数据
    URL参数和查询字符串
    身份验证和授权
    会议和饼干
    静态文件和媒体处理
    中间件和请求/响应处理
    数据验证和表单验证
    SQL语法和语句
    创建和更改表
    插入,更新和删除行
    查询和过滤数据
    加入表并结合结果
    索引和查询优化
    标准化和数据库设计
    触发和存储程序
    交易和并发
    SQL中的错误处理
    Python编程概念
    字符串操纵
    数学操作
    数据结构:列表,元组,词典
    递归
    分类和搜索算法
    时间和日期处理
    常用表达
    文件操作
    异常层次结构和流控制

What roles can I use the Python, Django & SQL Online Test for?

  • Python/ Django开发人员
  • 高级Django开发人员
  • 完整的堆栈开发人员-Python/django
  • 后端软件工程师-Python/django

How is the Python, Django & 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

  • Python编程技能
  • 高级Python概念
  • 设计有效的数据结构
  • 优化SQL查询和性能
  • 高级Django概念
  • 使用Django构建静止的API
  • 在Django中实施身份验证和授权
  • 使用复杂的数据库关系
  • 故障排除和调试Django应用程序
  • 实施高级SQL查询和优化

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

Singapore government logo

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


85%
减少筛查时间

Python, Django & 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 Python,Django和SQL测试?
Ready to use the Adaface Python,Django和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
✖️