CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

PHP and MySQL mock test: free online practice

15 to 30 random questions in 15 to 30 minutes, by the level you choose: php 8, pdo, security, sql queries, indexes and laravel. After you submit you get your score, your strong and weak topics, and the right answer with an explanation for every question.

Want to revise first? Read the PHP and MySQL interview questions and answers.

Choose your experience

Free with a CoreHRx Jobs account: you will be asked to sign in or create one first.

What does the PHP and MySQL mock test cover?

The test covers 12 topics across three levels. Each attempt picks 15 to 30 questions at random, by the level you choose, so every attempt is different.

  • SQL Queries
  • Indexes
  • PHP Core
  • Security
  • Laravel
  • OOP
  • Transactions
  • Arrays
  • PDO
  • Scaling
  • Schema Design
  • Sessions

Sample PHP and MySQL mock test questions

One question from each level, the way they appear in the test. A new set comes on the 1st of every month. Try it, then open the answer.

  1. FresherScaling

    Why should product images be served directly by Nginx or a CDN, not by a PHP script that reads the file and echoes it?

    • PHP cannot read binary files such as JPG and PNG
    • Each image request would tie up a PHP worker that pages need
    • Browsers refuse images that come from a PHP script
    • Nginx compresses JPG images into a much smaller size
    Show the answer

    Answer: Each image request would tie up a PHP worker that pages need. A PHP-FPM pool has a limited number of workers. If they are busy sending images, real page requests wait in a queue. Nginx and CDNs serve static files very cheaply. Use PHP only when a file needs a permission check.

  2. Intermediate (1-5 years)Arrays

    What does this code print?

    var_dump(in_array('1e1', ['10']), in_array('1e1', ['10'], true));
    • bool(true) bool(false)
    • bool(false) bool(false)
    • bool(true) bool(true)
    • bool(false) bool(true)
    Show the answer

    Answer: bool(true) bool(false). Without strict mode, two numeric strings are compared as numbers, and '1e1' is 10 in scientific notation, so it matches '10'. Passing true as the third argument makes in_array() use ===. Use strict mode when checking codes, OTPs or IDs.

  3. Experienced (5+ years)Indexes

    A listing sorts with ORDER BY category ASC, price DESC. Which MySQL 8 index lets it read rows in that order without a sort step?

    • INDEX (category, price)
    • INDEX (category ASC, price DESC)
    • INDEX (price DESC, category ASC)
    • Two separate indexes, on category and on price
    Show the answer

    Answer: INDEX (category ASC, price DESC). MySQL 8 supports real descending indexes. When sort directions are mixed, the index must store the columns in the same mix, or the query needs a filesort. A plain (category, price) index can only be read fully forwards or fully backwards.

Take the full PHP and MySQL mock test: 15 to 30 questions and 15 to 30 minutes, by level.

How is the PHP and MySQL mock test scored?

A question counts as right only when you pick exactly the right option, or all the right options where it says so; a question left blank counts as wrong. Your score is the share of the test's questions you got right (15 to 30, by level). The result also scores every topic, so you know what to revise before the interview.

  • 75% or more in a topica strength
  • 50% to 74%worth a revision
  • Under 50%a topic to work on

PHP and MySQL mock test: questions people ask

Is the PHP and MySQL mock test free?

Yes. The PHP and MySQL mock test is free. You need a free CoreHRx Jobs account to start it, so your score and the topics to work on are saved.

How many questions are in the PHP and MySQL mock test?

It depends on the level: Fresher has 15 questions in 15 minutes, Intermediate has 20 questions in 20 minutes, Experienced has 30 questions in 30 minutes. They are multiple-choice questions picked at random from a larger bank of PHP and MySQL questions at your level, so every attempt is different.

Which PHP and MySQL topics does the test cover?

The questions cover SQL Queries, Indexes, PHP Core, Security, Laravel, OOP, Transactions, Arrays, PDO, Scaling, Schema Design, Sessions. Your result shows how you did in each topic.

Which level should I choose?

Fresher if you are a student or have less than a year of experience, Intermediate for 1 to 5 years at work, and Experienced for 5 years or more.

Can employers see my PHP and MySQL score?

Only your best PHP and MySQL score, and only when it is 60% or more. It shows on the job applications you send on CoreHRx. Lower scores stay private.

Can I take the PHP and MySQL mock test again?

Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.

All mock tests