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

The Python, Django & SQL -test 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 Syntax en Fundamentals Gegevensstructuren in Python Het verwerken van uitzonderingen en fouten Crud -bewerkingen op SQL -tabellen Inzicht in SQL Joins en Indexes Basic Django Framework -concepten Django -modellen - het maken en wijzigen van databasetabellen Django -weergaven - Http -aanvragen en antwoorden afhandelen Werken met Django -sjablonen SQL CRUD -bewerkingen uitvoeren

Python, Django & SQL Online Test

Q: What topics are covered in the Python, Django & SQL Online Test?

Python Fundamentals Data structuren Crud -bewerkingen op tabellen Fouten en uitzonderingen hanteren Django Framework Basics Django -modellen en weergaven Django -sjablonen SQL CRUD -operaties SQL sluit zich aan en indexeert Python -programmering

About the test:

De Python-, Django- en SQL-test maakt gebruik van scenario-gebaseerde MCQ's om kandidaten te evalueren op hun bekwaamheid in Python-programmeertaal, Django Web Framework en SQL-database. De test beoordeelt het begrip van kandidaten van onderwerpen zoals object-relationele kaarten, databasemodellen, querysets, weergaven, sjablonen, middleware en SQL-query's. Kandidaten worden geëvalueerd op hun vermogen om deze technologieën te gebruiken om webtoepassingen te ontwikkelen met geavanceerde functies, evenals hun vaardigheid bij het schrijven van geoptimaliseerde en beveiligde SQL -query's voor database -interacties.

Covered skills:

Python Fundamentals
Crud -bewerkingen op tabellen
Django Framework Basics
Django -sjablonen
SQL sluit zich aan en indexeert

Data structuren
Fouten en uitzonderingen hanteren
Django -modellen en weergaven
SQL CRUD -operaties
Python -programmering

Preview this test

Bekijk Sample Scorecard

9 reasons why

Adaface Python, Django & SQL Test is the most accurate way to shortlist Python/ Django -ontwikkelaars

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:

Mogelijkheid om Python -code te schrijven met behulp van best practices en conventies
Bekendheid met Python -gegevensstructuren voor efficiënte gegevensmanipulatie
Vaardigheid bij het uitvoeren van CRUD -bewerkingen op SQL -tabellen
Mogelijk om fouten en uitzonderingen in Python af te handelen
Inzicht in de basisprincipes van Django Framework voor het bouwen van webapplicaties
Kennis van Django -modellen en weergaven voor database -interacties
Vaardigheid in het werken met Django -sjablonen voor het weergeven van dynamische inhoud
Mogelijkheid om CRUD -bewerkingen uit te voeren op SQL -databases
Kennis van SQL Joins en Indexes voor efficiënt ophalen van gegevens
Competentie in programmeren met Python

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.

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

Preview this test

Bekijk Sample Scorecard

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

Dit zijn slechts een klein monster uit onze bibliotheek met meer dan 10.000 vragen. De werkelijke vragen hierover Python, Django & SQL -test zal niet-googelbaar zijn.

🧐 Question
Medium ZeroDivisionError and IndexError Exceptions	Solve
What will the following Python code output?
Medium Session File Handling Dictionary	Solve
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?
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:
Medium Recursive Function Recursion Dictionary Lists	Solve
Consider the following Python code: 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? 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: 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: 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: 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: We want a QuerySet with all Person objects where retired == True and age != 45. Which of the following do you think we should use?
Medium Multi Select JOIN GROUP BY	Solve
Consider the following SQL table: How many rows does the following SQL query return?
Medium nth highest sales Nested queries User Defined Functions	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
Medium Select & IN Nested queries	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
Medium Sorting Ubers Nested queries Join Comparison operators	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
Hard With, AVG & SUM MAX() MIN() Aggregate functions	Solve
Consider the following SQL table: How many tuples does the following query return?
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
What will the following Python code output?
	Medium Session File Handling Dictionary	2 mins Python	Solve
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?
	Medium Max Code Arrays	2 mins Python	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:
	Medium Recursive Function Recursion Dictionary Lists	3 mins Python	Solve
Consider the following Python code: 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	4 mins Python	Solve
What does the below function ‘fun’ does? 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	2 mins Django	Solve
Review the following sample Django URL.conf: 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	3 mins Django	Solve
Review the following Django code for a banking application: 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: 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	2 mins Django	Solve
An HRTech startup has the following Django code: We want a QuerySet with all Person objects where retired == True and age != 45. Which of the following do you think we should use?
	Medium Multi Select JOIN GROUP BY	2 mins SQL	Solve
Consider the following SQL table: How many rows does the following SQL query return?
	Medium nth highest sales Nested queries User Defined Functions	3 mins SQL	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Medium Select & IN Nested queries	3 mins SQL	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Medium Sorting Ubers Nested queries Join Comparison operators	3 mins SQL	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	Hard With, AVG & SUM MAX() MIN() Aggregate functions	2 mins SQL	Solve
Consider the following SQL table: How many tuples does the following query return?
	Easy Registration Queue Logic Queues	30 mins Coding	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	30 mins Coding	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	💪 Difficulty	⌛ Time
	ZeroDivisionError and IndexError Exceptions	Python	Medium	2 mins	Solve
What will the following Python code output?
	Session File Handling Dictionary	Python	Medium	2 mins	Solve
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?
	Max Code Arrays	Python	Medium	2 mins	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:
	Recursive Function Recursion Dictionary Lists	Python	Medium	3 mins	Solve
Consider the following Python code: 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?
	Stacking problem Stack Linkedlist	Python	Medium	4 mins	Solve
What does the below function ‘fun’ does? 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.
	URL Dispatcher Routes	Django	Easy	2 mins	Solve
Review the following sample Django URL.conf: 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).
	External Bank Transfer Database Transactions	Django	Medium	3 mins	Solve
Review the following Django code for a banking application: 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: 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.
	Query retired people	Django	Medium	2 mins	Solve
An HRTech startup has the following Django code: We want a QuerySet with all Person objects where retired == True and age != 45. Which of the following do you think we should use?
	Multi Select JOIN GROUP BY	SQL	Medium	2 mins	Solve
Consider the following SQL table: How many rows does the following SQL query return?
	nth highest sales Nested queries User Defined Functions	SQL	Medium	3 mins	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Select & IN Nested queries	SQL	Medium	3 mins	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Sorting Ubers Nested queries Join Comparison operators	SQL	Medium	3 mins	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	With, AVG & SUM MAX() MIN() Aggregate functions	SQL	Hard	2 mins	Solve
Consider the following SQL table: How many tuples does the following query return?
	Registration Queue Logic Queues	Coding	Easy	30 mins	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
	Visitors Count Strings Logic	Coding	Medium	30 mins	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.

Reason #4

1200+ customers in 75 countries

Met Adaface konden we ons eerste screeningproces met ruim 75% optimaliseren, waardoor kostbare tijd vrijkwam voor zowel de rekruteringsmanagers als ons talentacquisitieteam!

Brandon Lee, Hoofd Mensen, Love, Bonito

Preview this test

Bekijk Sample Scorecard

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Python, Django & SQL -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.

Science behind Adaface tests

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Python, Django & SQL -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 & benchmarks

Bekijk Sample Scorecard

Preview this test

Bekijk Sample Scorecard

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

Learn more

Preview this test

Bekijk Sample Scorecard

About the Python, Django & SQL Assessment Test

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

The Python, Django & SQL -test 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 Syntax en Fundamentals
Gegevensstructuren in Python
Het verwerken van uitzonderingen en fouten
Crud -bewerkingen op SQL -tabellen
Inzicht in SQL Joins en Indexes
Basic Django Framework -concepten
Django -modellen - het maken en wijzigen van databasetabellen
Django -weergaven - Http -aanvragen en antwoorden afhandelen
Werken met Django -sjablonen
SQL CRUD -bewerkingen uitvoeren

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?

Gegevensstructuren
Gegevensstructuren verwijzen naar de manier Gegevens zijn georganiseerd, opgeslagen en toegankelijk in een computerprogramma. Deze vaardigheid wordt in de test gemeten om de kennis en vaardigheid van een kandidaat te evalueren bij het gebruik van verschillende gegevensstructuren zoals lijsten, woordenboeken, sets en tuples om programmeerproblemen efficiënt op te lossen.
Crud -bewerkingen op tabellen
CRUD -bewerkingen (maken, lezen, updaten, verwijderen) op tabellen omvatten het manipuleren van gegevens in een relationele database met behulp van SQL -query's. Deze vaardigheid wordt gemeten in de test om het vermogen van een kandidaat te peilen om met databases te werken, basisdatabasebewerkingen uit te voeren en gegevensintegriteit te garanderen.
fouten en uitzonderingen hanteren
fouten en uitzonderingenverlichting Verwijzing naar het proces van het identificeren, vangen en beheren van fouten of onverwachte gebeurtenissen in de uitvoering van een programma. Deze vaardigheid wordt in de test gemeten om de bekwaamheid van een kandidaat te beoordelen bij het schrijven van betrouwbare code die fouten sierlijk aankan en voorkomen dat het programma crasht.
Django Framework Basics </H4> <p> Django is een hoog- Niveau Python Web Framework waarmee ontwikkelaars robuuste en schaalbare webapplicaties kunnen bouwen. Deze vaardigheid wordt in de test gemeten om het begrip van een kandidaat te evalueren van de fundamentele concepten, componenten en workflow van het Django -framework. </p> <h4> django -modellen en weergaven
Django -modellen en weergaven zijn integraal Delen van het Django -framework. Modellen definiëren de gegevensstructuren en relaties in een Django -applicatie, terwijl weergaven de logica afhandelen achter renderingsjablonen en het verwerken van gebruikersverzoeken. Deze vaardigheid wordt in de test gemeten om de vaardigheid van een kandidaat bij het ontwerpen en implementeren van modellen en weergaven in Django te beoordelen.
django -sjablonen
Django -sjablonen worden gebruikt om de structuur, lay -out en lay -out te definiëren en te definiëren en Presentatie van webpagina's in Django -applicaties. Deze vaardigheid wordt in de test gemeten om het vermogen van een kandidaat te evalueren om dynamische en gebruiksvriendelijke webinterfaces te maken met behulp van het sjabloonsysteem van Django.
SQL Crud Operations
SQL CRUD-bewerkingen omvatten het uitvoeren van create, creëren, maken, Lees, update en verwijder bewerkingen over de gegevens die zijn opgeslagen in een relationele database met behulp van SQL -query's. Deze vaardigheid wordt in de test gemeten om de vaardigheid van een kandidaat te beoordelen in het zoeken, manipuleren en beheren van gegevens met behulp van SQL.
SQL Joins and Indexes </H4> <p> SQL Joins worden gebruikt om rijen uit meerdere te combineren van meerdere Tabellen op basis van gerelateerde kolommen, terwijl indexen worden gebruikt om de queryprestaties te optimaliseren door efficiënte gegevensstructuren te maken. Deze vaardigheid wordt in de test gemeten om het begrip van een kandidaat te evalueren van geavanceerde SQL -concepten en hun vermogen om complexe databasevragen te schrijven. </p> <h4> Python Programming
Python -programmering verwijst naar de algemene kennis en expertise Bij het gebruik van de Python-taal om real-world problemen op te lossen. Deze vaardigheid wordt in de test gemeten om de vaardigheid van een kandidaat te beoordelen in het schrijven van pythoncode, het implementeren van algoritmen en het toepassen van best practices om software van hoge kwaliteit te ontwikkelen.
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 -test to be based on.
Python Syntax
Variabelen en gegevenstypen
Voorwaardelijke stellingen
Loopconstructies
Functies en modulair programmeren
Uitzonderingsbehandeling
Bestandsbehandeling
Lijsten en tupels
Woordenboeken en sets
Klassen en objecten
Erfenis en polymorfisme
Bestandsinvoer/uitvoer
Verbinding maken met een database
Tafels en schema maken
Gegevens invoegen en bijwerken
Gegevens ophalen en opvragen
Gegevens verwijderen en tabellen laten vallen
Primaire toetsen en buitenlandse toetsen
Indexen en prestatie -optimalisatie
Fouttypen en hanteringstechnieken
Model-view-controller (MVC) architectuur
URL -routering
Bekijk functies en op klassen gebaseerde weergaven
Modellen en databasemigraties
Vormen en vormafhandeling
Sjabloon Syntaxis en tags
Sjabloon erfenis en contextvariabelen
Querysets en databasevragen
Object-relationele mapping (ORM)
Één-op-één, één-op-veel en veel-op-veel relaties
Gegevens filteren en bestellen
Gegevens aggregeren en annoteren
URL -parameters en queryreeksen
Authenticatie en authorisatie
Sessies en koekjes
Statische bestanden en media -afhandeling
Middleware en aanvraag/antwoordverwerking
Gegevensvalidatie en vormvalidatie
SQL -syntaxis en verklaringen
Het maken en wijzigen van tafels
Rijen invoegen, bijwerken en verwijderen
Gegevens opvragen en filteren
Tafels aansluiten en resultaten combineren
Indexen en query -optimalisatie
Normalisatie en database -ontwerp
Triggers en opgeslagen procedures
Transacties en gelijktijdigheid
Foutafhandeling in SQL
Python programmeerconcepten
Stringmanipulatie
Wiskundige bewerkingen
Gegevensstructuren: lijsten, tupels, woordenboeken
Herhaling
Sorteer- en zoekalgoritmen
Tijd- en datumbehandeling
Normale uitdrukkingen
Bestandsmanipulatie
Uitzonderingshiërarchie en stroomregeling

Preview this test

Bekijk Sample Scorecard

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

Python/ Django -ontwikkelaar
Senior Django -ontwikkelaar
Volledige stapelontwikkelaar - Python/Django
Backend Software Engineer - 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 programmeervaardigheden
Geavanceerde Python -concepten
Efficiënte gegevensstructuren ontwerpen
SQL -query's en prestaties optimaliseren
Geavanceerde Django -concepten
Restful API's bouwen met Django
Verificatie en autorisatie implementeren in Django
Werken met complexe databaserelaties
Problemen oplossen en debuggen django -applicaties
Implementatie van geavanceerde SQL -query's en optimalisaties

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

Preview this test

Bekijk Sample Scorecard

De rekruteringsmanagers waren van mening dat ze door de technische vragen die ze tijdens de panelgesprekken stelden, konden zien welke kandidaten beter scoorden, en onderscheidden ze zich met degenen die niet zo goed scoorden. Zij zijn zeer tevreden met de kwaliteit van de kandidaten op de shortlist van de Adaface-screening.

85%

Vermindering van de screeningstijd

Bekijk volledige case study

Python, Django & SQL Hiring Test Veelgestelde vragen

Kan ik meerdere vaardigheden combineren in één aangepaste beoordeling?

Ja absoluut. Aangepaste beoordelingen zijn opgezet op basis van uw functiebeschrijving en bevatten vragen over alle must-have vaardigheden die u opgeeft.

Heeft u functies tegen latere of proctoring op hun plaats?

We hebben de volgende anti-cheating-functies op zijn plaats:

Niet-googelbare vragen
IP Proctoring
Web Proctoring
Webcam Proctoring
Plagiaatdetectie
Beveilig browser

Lees meer over de Proctoring -functies.

Hoe interpreteer ik testscores?

Het belangrijkste om in gedachten te houden is dat een beoordeling een eliminatietool is, geen selectietool. Een vaardighedenbeoordeling is geoptimaliseerd om u te helpen kandidaten te elimineren die niet technisch gekwalificeerd zijn voor de rol, het is niet geoptimaliseerd om u te helpen de beste kandidaat voor de rol te vinden. Dus de ideale manier om een beoordeling te gebruiken is om een drempelscore te bepalen (meestal 55%, wij helpen u benchmark) en alle kandidaten uit te nodigen die boven de drempel scoren voor de volgende interviewrondes.

Voor welk ervaringsniveau kan ik deze test gebruiken?

Elke ADAFACE -beoordeling is aangepast aan uw functiebeschrijving/ ideale kandidaatpersonage (onze experts van het onderwerp zullen de juiste vragen kiezen voor uw beoordeling uit onze bibliotheek van 10000+ vragen). Deze beoordeling kan worden aangepast voor elk ervaringsniveau.

Krijgt elke kandidaat dezelfde vragen?

Ja, het maakt het veel gemakkelijker voor u om kandidaten te vergelijken. Opties voor MCQ -vragen en de volgorde van vragen worden gerandomiseerd. We hebben anti-cheating/proctoring functies. In ons bedrijfsplan hebben we ook de optie om meerdere versies van dezelfde beoordeling te maken met vragen over vergelijkbare moeilijkheidsniveaus.