Search test library by skills or roles
⌘ K

PHP, Laravel and SQL Online Test

About the test:

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

  • 句法
  • 循环
  • 操作员
  • 变量
See all covered skills

9 reasons why
9 reasons why

Adaface PHP, Laravel and SQL Online Test is the most accurate way to shortlist PHP Developers



Reason #1

Tests for on-the-job skills

The PHP, Laravel and 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.

Non-googleable questions & proctoring features enable you to be comfortable with conducting assessments online. The PHP, Laravel and SQL Online Test is ideal for helping recruiters identify which candidates have the skills to do well on the job.

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.

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

🧐 Question

Easy

Array Replace
Arrays
Solve
What will the following PHP code output?
 image
// OPTION ONE
Array
(
		[0] => basappa
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => fakhruddin
)

// OPTION TWO
Array
(
		[0] => hidayatullah
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => fakhruddin
)

// OPTION THREE
Array
(
		[0] => fakhruddin
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => hidayatullah
)

// OPTION FOUR
Array
(
		[0] => basappa
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
)

Medium

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

Medium

Exceptions
Exception
Solve
What does the following code output?
 image

Medium

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

Medium

Inject instances into routes
Solve
Your friend Sabrina is interning with a data analytics startup. For their app, they want to be able to automatically inject the instances of the model into their routes. Which of the following would you recommend?
 image

Medium

Blog posts: One to many relationship
Solve
Our client, Naval Ravikant who is a very popular angel investor wrote a blog post which went viral. There are a very large number of comments on his blog post. Which of the following snippets of code should we add to the post model to define a one-to-many relationship?
 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

Easy

Registration Queue
Logic
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

Longest Road
logic
hashmaps
Solve
A startup company E-Motors is building driverless automated cars. The car contains a sensor that checks the road quality for the next N meters to decide the optimal speed at which the cars should move. We are given recorded data by the sensor in the form of an array, where each element of the array is the rating given to 1 meter of the road in sequence. 

The rating given by the sensor is from 1 to 100, where 100 represents the road with the best condition, and any rating above 60 is optimal. Find the longest stretch of road in meters that is categorized as optimal by the sensor.

The input is an array of "strings" which needs to be converted from string to integer/number inside the function.

Medium

Visitors Count
Strings
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

Array Replace
Arrays
2 mins
PHP
Solve

Medium

Alter and Change
OOPs
2 mins
PHP
Solve

Medium

Exceptions
Exception
2 mins
PHP
Solve

Medium

PDO MySQL
Database Connection
2 mins
PHP
Solve

Medium

Inject instances into routes
2 mins
Laravel
Solve

Medium

Blog posts: One to many relationship
2 mins
Laravel
Solve

Medium

Multi Select
2 mins
SQL
Solve

Easy

Select & IN
3 mins
SQL
Solve

Medium

With, AVG & SUM
2 mins
SQL
Solve

Easy

Registration Queue
Logic
30 mins
Coding
Solve

Medium

Longest Road
logic
hashmaps
25 mins
Coding
Solve

Medium

Visitors Count
Strings
30 mins
Coding
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Array Replace
Arrays
PHP
Easy2 mins
Solve
Alter and Change
OOPs
PHP
Medium2 mins
Solve
Exceptions
Exception
PHP
Medium2 mins
Solve
PDO MySQL
Database Connection
PHP
Medium2 mins
Solve
Inject instances into routes
Laravel
Medium2 mins
Solve
Blog posts: One to many relationship
Laravel
Medium2 mins
Solve
Multi Select
SQL
Medium2 mins
Solve
Select & IN
SQL
Easy3 mins
Solve
With, AVG & SUM
SQL
Medium2 mins
Solve
Registration Queue
Logic
Coding
Easy30 minsSolve
Longest Road
logic
hashmaps
Coding
Medium25 minsSolve
Visitors Count
Strings
Coding
Medium30 minsSolve
Reason #4

1200+ customers in 75 countries

Brandon

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

Reason #5

Designed for elimination, not selection

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

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the PHP, Laravel & 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 & 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


What topics are covered in the PHP, Laravel and SQL Online Test?

句法
操作员
循环
变量
错误修复
职能
面向对象的编程(OOPS)
类和对象
继承和多符号
全球范围和范围
安全
会议
数组
会议
排序
迭代
例外
XML/JSON
功能编程
路线
控制器
视图

该框架与公众/。 htaccess文件,用于允许没有index.php的URL。

迁移
ORM

数据库查询构建器为创建和运行数据库查询提供了方便,流利的接口。

修补匠
形式
文件

资源控制器用于创建一个控制器,该控制器处理您应用程序存储的所有HTTP请求。

中间
会议

事件提供了一个简单的观察者模式实现,使人们可以订阅并聆听应用程序中发生的各种事件。

雄辩的克鲁德
雄辩的关系

Cookie可以由Laravel的Global Cookie Helper创建。

n+1查询问题
急切的加载
文件上传

Laravel允许您轻松创建可能在后台处理的排队作业。

数据库种子
数据库工厂
授权

软件包是将功能添加到Laravel的主要方式。

验证
查询范围
缓存

API是一个软件中介机构,允许两个应用程序相互交流。

观察者
事件
听众和订户

测试驱动的开发是一种编码实践,您首先编写测试,然后编写代码通过该测试,通常在短时间迭代周期中。

外墙

Laravel Dusk提供了一种表现力,易于使用的浏览器自动化和测试API。

黄昏
例外
关系模型
SQL基础知识
SQL功能
数据修改语言
数据查询语言
克鲁德
SQL过滤 /在哪里语句
子征服
索引
3个有价值的逻辑
SQL加入
窗口功能
日期过滤和时间戳
聚合功能
操作员优先
顺序
通过...分组
自上而下的设计
自下而上的设计
实体关系图
正常化
数据库类型
多桌选择
许可管理
备份策略
交易
数据类型
视图
碎片
复制
备份
垂直 +水平缩放
分布式与集中数据库
数据库安全性
SQL注射
访问控制
计算机基础
信件编码
数字编码
替代
编码编码难题
非语言推理
SQL概念
商业分析
编码编码
编程语言
计算机架构
基本DBMS概念
坚实的原则
自动化系统
做决定
非语言推理
解决问题的方法
Singapore government logo

The hiring managers felt that through the technical questions that they asked during the panel interviews, they were able to tell which candidates had better scores, and differentiated with those who did not score as well. They are highly satisfied with the quality of candidates shortlisted with the Adaface screening.


85%
reduction in screening time

FAQs

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

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

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

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

  • 不可解决的问题
  • 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 PHP, Laravel & SQL Test?
Ready to use the Adaface PHP, Laravel & SQL Test?
Chat with us
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
✖️