MySQL and SQL Online Test

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

Jobseekers: Get a Certificate

Companies: Try First, Pay Later

Used by:

The MySQL and SQL online test assesses candidates' knowledge of SQL queries, relational database concepts, and specific MySQL features.

It's an ideal test for pre-employment screening. A good database admin or back-end developer working exclusively on a MySQL server database needs to be able to use features specific to MySQL to interface efficiently with the database.

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

Recommended Job Roles

Data Analyst

Database Administrator

MySQL Database Administrator

MySQL Developer

SQL Developer

Sample Candidate Report

Open Sample 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)

Solve Question

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

Solve Question

Enrollment

5min

Easy

CODE

SQL Conditions Update Public

A table containing the students enrolled in a yearly course has incorrect data in records with ids between 20 and 100 (inclusive).

TABLE enrollments
  id INTEGER NOT NULL PRIMARY KEY
  year INTEGER NOT NULL
  studentId INTEGER NOT NULL

Write a query that updates the field 'year' of every faulty record to 2015.

Solve Question

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, Poll, Rectangles, Retirees, Authors, Countries, Employee Manager, Merge Stock Index, Cheapest Product, Movies Live, ATM Locations, Department Report, Developers, Delete Orders, Restaurant Menu, Roads, Sales, Student Activities, Transactions, Projects, Youngest Child, SMS Messages, Tasks, Ingredients, Autocomplete, Dot Items, JSON Stock, Cargo Concat, Employee Sales, Employee Tree, Bank Branches, Hospital Patients, Menu Items, Ban Users

Skills

SQL Aggregation Subqueries Indexes Conditions Insertion Language Joins Union Constraints Database Schema Bug fixing Delete Update Views Performance tuning MySQL String Functions JSON Window functions Common Table Expression

Score Distribution

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

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 criticizes the others. Many of these methods look legitimate, but are based on...