This PHP and SQL Online Test
Separates Good From Bad Hires

Screen with work-sample questions

Work-samples are the best predictor of work performance. 8,000+ companies use TestDome premium questions.

About the test

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

It's an ideal test for pre-employment screening. A good PHP developer needs to not only solve problems using PHP but also write and analyze SQL queries used for communication with the database.

This online test requires candidates to solve coding problems in PHP and to write SQL queries that extract, combine, and manipulate data.

Sample public questions

You're maintaining the PHP back-end of a Tree Planting website.

The registerForEvent function is called by the server when interested people fill a form to register for a tree planting event.

The register function it calls performs the registration logic.

Consider the code for the registerForEvent function:

function registerForEvent($name, $seedBagsNeeded)
{
    $sanitizedName = filter_var($name, FILTER_SANITIZE_SPECIAL_CHARS);
    $filteredBagsNeeded = filter_var($seedBagsNeeded, FILTER_VALIDATE_INT);
    register($sanitizedName, $filteredBagsNeeded);
}

What is correct about the filtering and sanitization done in the code above?

PHP
Sanitization
Validation
Easy
5 min
mca
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
SQL
Aggregation
Select
Easy
3 min
code
Public

For jobseekers: get certified

Earn a free certificate by achieving top 25% on the PHP and SQL test with public questions.

Take a Certification Test

Sample silver certificate

Peter Gibbons

Java and SQL

TestDome
Certificate

TestDome logo on certificate

For companies: premium questions

Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.

Sign Up to Offer this Test

73 more premium PHP and SQL questions

  Greeter,   Last Key,   Height,   Shipping,   Numbers to Text,   Array Sum,   Category Tree,   Chain Link,   Hobbies,   Paragraph,   Products,   Username,   View Count,   Language Teacher,   Crop Ratio,   Log Parser,   Kilometer Converter,   String Occurrence,   Special Actions,   Array Search,   Roads,   Authors,   Autocomplete,   Ban Users,   Bank Branches,   Cheapest Product,   Countries,   Developers,   Hospital Patients,   Index Performance,   Menu Items,   Movies,   Projects,   Rectangles,   Restaurant Menu,   Retirees,   SMS Messages,   Poll,   Users and Accounts,   Matching Clothes,   Agents,   Sales,   Employee Manager,   Auto Show,   Delete Orders,   Welfare Organization,   Tasks,   Manager Sales,   Student Rankings,   Student Activities,   Youngest Child,   Movies Live,   Department Report,   Ingredients,   Average Salary,   Movie Genres,   Segment,   River Discharge,   Vectors,   ATM Locations,   Cookie,   Read Write Execute,   Read First Line,   Filter,   Transactions,   Fire Dragon,   Unique Numbers,   Shipping Service,   Action Stack,   Flower Shop,   PC Parts Seller,   Merge Stock Index,   Date Transform.

Skills and topics tested

  • PHP
  • Language
  • Arrays
  • Arithmetic
  • Strings
  • Pass by Reference
  • Associative Arrays
  • Exceptions
  • Linked List
  • Iteration
  • Regex
  • JSON
  • Serialization
  • Sorting
  • Inheritance
  • OOP
  • Bug Fixing
  • Integer Division
  • XML
  • Method Overriding
  • Stream
  • Recursion
  • SQL
  • Conditions
  • Views
  • Select
  • Create Index
  • Database Schema
  • Performance Tuning
  • Alter Table
  • Constraints
  • Create Table
  • Aggregation
  • Subqueries
  • Ordering
  • Indexes
  • Group by
  • Update
  • Insert
  • Joins
  • Left Join
  • Right Join
  • Delete
  • SQL CASE
  • Union
  • CTE
  • Database Normalization
  • Session
  • Interfaces
  • Algorithmic Thinking
  • Callback
  • Stack
  • Null Coalescing Operator
  • Classes
  • Properties

For job roles

  • PHP Developer
  • SQL Developer
  • Web Developer

Solve all your skill testing needs

150+ Pre-made tests

From web development and database administration to project management and customer support. See all pre-made tests.

Multi-skills Test

Mix questions for different skills or even custom questions in one test. See an example.

How TestDome works

1
Choose a pre-made test or create a custom test.
2
Invite candidates via email, URL or your ATS
3
Candidates take a test remotely
4
Sort candidates and get individual reports

Want to know more?

Not exactly what you're looking for?

Related PHP and SQL Programming Tests: