Search test library by skills or roles
⌘ K

PHP, Drupal & SQL Online Test

The PHP, Drupal & SQL Test uses scenario-based MCQs to evaluate candidates on their proficiency in PHP programming language, Drupal content management system, and SQL database. The test assesses candidates' understanding of topics such as module development, theming, database interactions, Drupal architecture, SQL queries, and database design principles. Candidates are evaluated on their ability to use these technologies to develop custom modules, themes, and configurations for Drupal, as well as their proficiency in writing efficient and effective SQL queries for data manipulation and retrieval.

Get started for free
Preview questions

Screen candidates with a 50 mins test

Test duration:  50 mins
Difficulty level:  Moderate
Availability:  Ready to use
Questions:
  • 5 PHP MCQs
  • 5 Drupal MCQs
  • 5 SQL MCQs
  • 1 PHP Coding Question
Covered skills:
PHP Syntax Basics
PHP Data Structures
PHP OOPs
SQL CRUD Operations
SQL Joins and Indexes
Drupal Modules and Themes
Drupal routes and controllers
PHP Programming
Get started for free
Preview questions

Use Adaface tests trusted by recruitment teams globally

Adaface is used by 1500+ businesses in 80 countries.

Adaface skill assessments measure on-the-job skills of candidates, providing employers with an accurate tool for screening potential hires.

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte NCS Sokrati J&T Express Capegemini

Use the PHP, Drupal & SQL Test to shortlist qualified candidates

The PHP, Drupal & 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:

  • Efficient handling of PHP syntax basics
  • Strong understanding of PHP data structures
  • Proficiency in PHP OOPs concepts
  • Expertise in SQL CRUD operations
  • Deep knowledge of SQL joins and indexes
  • Ability to develop Drupal modules and themes
  • Skilled in Drupal routes and controllers
  • Proficient in PHP programming
  • Capability to write efficient PHP code
  • Strong problem-solving and debugging skills
Get started for free
Preview questions

Screen candidates with the highest quality 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

These are just a small sample from our library of 15,000+ questions. The actual questions on this PHP, Drupal & SQL Test will be non-googleable.

🧐 Question

Medium

Dynamic Function Calls
Arrays
Strings
Functions
Solve
Consider the following PHP pseudo code:
 image
The processArray function processes the $data array based on the transformation operations defined in the $operations array. The operations array dictates which transformation function to call for each sub-array key. What will be the output of the above code?
 image

Hard

Alter and Change
OOPs
Solve
What does the following code output?
 image

Hard

Exceptions
Exceptions
Solve
What does the following code output?
 image

Easy

PDO MySQL
Database Connections
Solve
Consider the following table data and PHP code. What is the result?
 image

Medium

Session Management and Object Serialization
Sessions
Serialization
Solve
Consider the following PHP script:
 image
Assuming you run the script twice in a row without clearing the session data, what will be the output on the second run?

Medium

Access content
Routes
Controllers
Solve
Review the following Drupal code:
 image
 image
Pick the correct statements:

A: When /sample is accessed, access is allowed without checking for permissions and SampleController::content method is invoked
B: When /sample is accessed, ‘access content’ permission is checked on the accessing user and, if access is granted, SampleController::content method is invoked
C: When /sample is accessed, the page outputs ‘A’ on the page with title ‘B’
D: When /sample is accessed, the page outputs ‘B’ on the page with title ‘A’
E: When /sample is accessed, the page outputs ‘A’ on the page with no title
F: When /sample is accessed, the page outputs nothing on the page with title ‘B’

Medium

Insert Queries
Database API
Solve
Review the following Drupal code:
 image
Pick the correct statements:
A: Both the snippets create the queries to run but are not executed until $query→execute() is called
B: When Snippet 2 is run, the insert statements are executed one after the other always. Equivalent to calling →execute() two separate times for each item in $values.
C: When Snippet 2 is run, depending on the database, the insert statements will be executed together in a transaction
D: The return value of $result→execute will be the inserted record entry

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

Dynamic Function Calls
Arrays
Strings
Functions

2 mins

PHP
Solve

Hard

Alter and Change
OOPs

2 mins

PHP
Solve

Hard

Exceptions
Exceptions

2 mins

PHP
Solve

Easy

PDO MySQL
Database Connections

2 mins

PHP
Solve

Medium

Session Management and Object Serialization
Sessions
Serialization

2 mins

PHP
Solve

Medium

Access content
Routes
Controllers

2 mins

Drupal
Solve

Medium

Insert Queries
Database API

2 mins

Drupal
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
Dynamic Function Calls
Arrays
Strings
Functions
PHP
Medium2 mins
Solve
Alter and Change
OOPs
PHP
Hard2 mins
Solve
Exceptions
Exceptions
PHP
Hard2 mins
Solve
PDO MySQL
Database Connections
PHP
Easy2 mins
Solve
Session Management and Object Serialization
Sessions
Serialization
PHP
Medium2 mins
Solve
Access content
Routes
Controllers
Drupal
Medium2 mins
Solve
Insert Queries
Database API
Drupal
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

Test candidates on core PHP, Drupal & SQL Hiring Test topics

PHP Syntax Basics: This skill measures the understanding of basic syntax rules and constructs in PHP programming. It includes knowledge of variables, data types, operators, control structures, and functions. Evaluating this skill helps assess the candidate's ability to write syntactically correct PHP code and their familiarity with the core concepts of the language.

PHP Data Structures: This skill assesses the candidate's familiarity with various data structures in PHP, such as arrays, strings, and objects. It includes understanding how to manipulate data in these structures, access elements, perform operations like sorting and filtering, and implement algorithms efficiently. This skill evaluation provides insights into the candidate's ability to work with different types of data and their knowledge of PHP's built-in data structures.

PHP OOPs: This skill measures the candidate's understanding of object-oriented programming concepts in PHP. It includes knowledge of classes, objects, inheritance, polymorphism, and encapsulation. Evaluating this skill helps assess the candidate's ability to design and implement modular, reusable, and maintainable code using object-oriented principles.

SQL CRUD Operations: This skill assesses the candidate's proficiency in performing CRUD (Create, Read, Update, Delete) operations using SQL queries. It includes knowledge of SQL syntax, understanding how to interact with databases, and writing queries for creating, retrieving, updating, and deleting records. Evaluating this skill helps determine the candidate's ability to work with data in a relational database management system.

SQL Joins and Indexes: This skill measures the candidate's understanding of SQL joins and indexes. It includes knowledge of different types of joins like inner, outer, and cross joins, and the ability to formulate and execute complex join queries. Additionally, it involves understanding the concept of indexes and their significance in optimizing database performance. Evaluating this skill helps assess the candidate's ability to incorporate efficient querying and data retrieval techniques in database applications.

Drupal Modules and Themes: This skill assesses the candidate's familiarity with creating and customizing modules and themes in the Drupal content management system. It includes knowledge of Drupal's architecture, hooks, module development, and theme building. Evaluating this skill helps determine the candidate's ability to extend the functionality of Drupal and create visually appealing and user-friendly websites using custom modules and themes.

Drupal routes and controllers: This skill measures the candidate's ability to define routes and implement controllers in the Drupal framework. It includes knowledge of Drupal's routing system, routing configuration, and implementing controller actions. Evaluating this skill helps assess the candidate's ability to create and manage URLs/routes and handle user requests effectively in Drupal.

PHP Programming: This skill evaluates the candidate's overall proficiency in PHP programming. It includes a combination of all the aforementioned skills - syntax, data structures, object-oriented programming, and database interaction. Assessing this skill provides an overall understanding of the candidate's PHP programming abilities and their potential to work effectively on PHP-based projects.

Get started for free
Preview questions

Make informed decisions with actionable reports and benchmarks

View sample scorecard

Screen candidates in 3 easy steps

Pick a test from over 500+ tests

The Adaface test library features 500+ tests to enable you to test candidates on all popular skills- everything from programming languages, software frameworks, devops, logical reasoning, abstract reasoning, critical thinking, fluid intelligence, content marketing, talent acquisition, customer service, accounting, product management, sales and more.

Invite your candidates with 2-clicks

Make informed hiring decisions

Get started for free
Preview questions

Try the most advanced candidate assessment platform

ChatGPT Protection

Non-googleable Questions

Web Proctoring

IP Proctoring

Webcam Proctoring

MCQ Questions

Coding Questions

Typing Questions

Personality Questions

Custom Questions

Ready-to-use Tests

Custom Tests

Custom Branding

Bulk Invites

Public Links

ATS Integrations

Multiple Question Sets

Custom API integrations

Role-based Access

Priority Support

GDPR Compliance


Pick a plan based on your hiring needs

The most advanced candidate screening platform.
14-day free trial. No credit card required.

From
$15
per month (paid annually)
love bonito

With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!

Brandon Lee, Head of People, Love, Bonito

Brandon
love bonito

It's very easy to share assessments with candidates and for candidates to use. We get good feedback from candidates about completing the tests. Adaface are very responsive and friendly to deal with.

Kirsty Wood, Human Resources, WillyWeather

Brandon
love bonito

We were able to close 106 positions in a record time of 45 days! Adaface enables us to conduct aptitude and psychometric assessments seamlessly. My hiring managers have never been happier with the quality of candidates shortlisted.

Amit Kataria, CHRO, Hanu

Brandon
love bonito

We evaluated several of their competitors and found Adaface to be the most compelling. Great library of questions that are designed to test for fit rather than memorization of algorithms.

Swayam Narain, CTO, Affable

Brandon

Have questions about the PHP, Drupal & SQL Hiring Test?

How does pricing work?

You can check out our pricing plans.

Can I customize the test?

Yes, absolutely. Custom assessments are set up within 48 hours based on your job description, and will include questions on all must-have skills you specify. Here's a quick guide on how you can request a custom test. You can also customize a test by uploading your own questions.

Can I combine multiple skills into one test?

Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify. Here's a quick guide on how you can request a custom test.

What roles can I use the PHP, Drupal & SQL Test for?

Here are few roles for which we recommend this test:

  • PHP Developer
  • Drupal Developer
  • Full Stack Developer
Can I see a sample test, or do you have a free trial?

Yes!

The free trial includes one sample technical test (Java/ JavaScript) and one sample aptitude test that you will find in your dashboard when you sign up. You can use it to review the quality of questions and the candidate experience of giving a test on Adaface.

You can preview any of the 500+ tests and see the sample questions to decide if it would be a good fit for your requirements.

How do I interpret test scores?

The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

I'm a candidate. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

customers across world
Join 1500+ companies in 80+ countries.
Try the most candidate friendly skills assessment tool today.
g2 badges
Ready to use the Adaface PHP, Drupal & SQL Test?
Ready to use the Adaface PHP, Drupal & SQL Test?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
Terms Privacy Trust Guide
ada
Ada
● Online
Previous
Score: NA
Next
✖️