PHP, MySQL, and SQL Online Test

TestDome skill assessments are used by more than 6800 companies and 450,000 individual test takers.

Jobseekers: Get a Certificate

Take a Practice Test

Companies: Try First, Pay Later

Sign Up To Use This Test
 Used by: 

The PHP, MySQL and SQL online test assesses candidates' knowledge of programming in the PHP language, as well as their ability to use MySQL and SQL.

It's an ideal test for pre-employment screening. A good PHP developer, who is working exclusively on an MySQL server database layer, needs to not only solve problems using PHP, but also to write and analyze SQL queries that are used for communication with the database and to use MySQL-specific features to interface efficiently with a database. 

This online test requires candidates to solve coding problems in PHP, answer multiple-choice questions about MySQL and write SQL queries that extract, combine, and manipulate data.

Sample Candidate Report


Sample Free Questions

Paginate Users

3min
  -  
Easy 
  -  
MCA

MySQL Pagination Public New

Consider the following table:

CREATE TABLE users (
  id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) NOT NULL
);

The following query is used to paginate the table:

SELECT * FROM users ORDER BY username LIMIT 5 OFFSET 15;

Select all the true statements about this method of pagination.

(multiple correct answers possible)

Students

3min
  -  
Easy  
  -  
CODE

SQL Aggregation Public

Given the following data definition, write a query that returns the number of students whose first name is John.

TABLE students
   id INTEGER PRIMARY KEY,
   firstName VARCHAR(30) NOT NULL,
   lastName VARCHAR(30) NOT NULL

File Owners

10min
  -  
Easy  
  -  
CODE

PHP Language Public

Implement a groupByOwners function that:

  • Accepts an associative array containing the file owner name for each file name.
  • Returns an associative array containing an array of file names for each owner name, in any order.

For example, for associative array ["Input.txt" => "Randy", "Code.py" => "Stan", "Output.txt" => "Randy"] the groupByOwners function should return ["Randy" => ["Input.txt", "Output.txt"], "Stan" => ["Code.py"]].

Use Free Questions On a Trial Plan

Premium Questions

The premium question library contains our unique, hand-crafted questions. We offer a refund if you find any of them answered online.

Questions
Movies, Index Performance, Tasks, Poll, Rectangles, Retirees, Authors, Countries, Employee Manager, Merge Stock Index, Cheapest Product, Juggling Shop, Movies Live, ATM Locations, Autocomplete, Ban Users, Department Report, Developers, Ingredients, Delete Orders, Restaurant Menu, Roads, Sales, Student Activities, Transactions, Projects, Hospital Patients, Bank Branches, Menu Items, Youngest Child, SMS Messages, Employee Sales, Dot Items, Employee Tree, JSON Stock, Cargo Concat, Cookie, Read Write Execute, Chain Link, Numbers to Text, Height, Username, Unique Numbers, Shipping, Products, Array Sum, Crop Ratio, Filter, Paragraph, Hobbies, Category Tree, Last Key, View Count, Needle, Vectors, Programmer Teacher, Array Search, Word Count, Log Parser, Date Transform, Greeter, Read First Line, Segment, Chicken
Skills
SQL Aggregation Subqueries Indexes Joins Conditions Insertion Language Union PHP Constraints Database Schema Performance tuning Bug fixing Update Delete Views MySQL Window functions String Functions Common Table Expression JSON Arithmetic Strings Data structures Algorithmic thinking Searching Serialization Sorting Arrays Iteration Stream OOP Recursion Exceptions
Score Distribution
Loading...
Pricing For Premium Questions

Fully Customizable Tests

Add questions from our question library.
Create your own questions.
Customize test duration, number of questions, passing score, web proctoring, and more.
Create Free Account

Private Concierge

Send us an email with an explanation of your testing needs and a list of candidates. We will create an appropriate test, invite your candidates, review their results, and send you a detailed report.

What Others Say
TestDome user reviews on G2 Crowd
Simple, straight-forward technical testing

Testdome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.

Jan Opperman, Grindrod Bank

Very smooth, well supported, great for assessing candidates

Very Prompt and helpful support when needed, we were looking to work with a third party to write and set up new tests, testdome was able to quickly set up and support a method to do this, allowing us to start testing candidates straight away.

George Offer, Guided Solutions

Easy to use and efficient for testing developers of different levels

It provides us an opportunity to set our own timing policy, to choose from variety of questions from different areas and with difficulty gradation. Also it is great that TestDome provides free of charge tests for candidates to prepare and check how online IDE works. And support is always ready to help:)

Alexandra Bulka, WorkFusion

On the TestDome Blog

Screening Applicants: The Good, the Bad and the Ugly

Since we’re all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they’ve been screening people for many years, so they must know how to do it right?

Not really. I was surprised to discover that many experts disagree with each other. Everybody praises their pet method and criticises the others. Many of these methods look legitimate, but are based on...

How TestDome Works

How TestDome Works

Want to know more? Check out our tour or contact us below.

Check Tour
or
Schedule a Demo

The TestDome Advantage

500+ premium, hand-crafted questions for 30+ job skills and 10+ coding languages.
Proctored tests, API access, and Applicant Tracking System (ATS) Integration.
Questions with small samples of actual work instead of academic problems.

Flexible Pricing

No monthly subscription or setup fee. No minimum contract period. You only pay for the candidates you test.

View Pricing

Not exactly what you're looking for?

Related Programming Tests: