SQL Online Tests

Choose an SQL online test to assess desired programming skills.

We cover 4 major databases (MS SQL Server, MySQL, Oracle and PostgreSQL) as well as ANSI standard of SQL in case you don't need a vendor-specific SQL test.

The question set is mostly the same between each version of the test; the differences are primarily in syntax for different DBMS, e.g. top/limit/fetch first clauses. The only exception is the MySQL test, which replaces the question regarding ranking functions as MySQL doesn't support them.


MySQL

15 questions total, 40 minutes maximum, for mid-level programmers

MS SQL Server

15 questions total, 40 minutes maximum, for mid-level programmers

Oracle

15 questions total, 40 minutes maximum, for mid-level programmers

PostgreSQL

15 questions total, 40 minutes maximum, for mid-level programmers

SQL (ANSI Format)

15 questions total, 40 minutes maximum, for mid-level programmers


Sample SQL Test Question

Consider the following database tables:

Sample SQL Test Question

While peer reviewing a colleague's work, you stumble across the following SQL query, which is supposed to return how many subscriptions each of your customers has:

SQL Query

What is wrong with this SQL query?

Answers

  1. It does not return customers who have no subscriptions.
  2. It returns NULL instead of 0 for customers who have no subscriptions.
  3. It returns more than one record for customers who have more than one subscription.

The correct answer is 2.


Register Download Sample Report

Made by Professionals

Other Programming Tests