Test your Oracle Database skills

Here at Oracle Dev Gym (formerly the PL/SQL Challenge) we're dedicated to helping you improve your Oracle knowledge. To do this we've built a library of quizzes covering all aspects of developing applications on Oracle Database. Key focus areas are:

  • SQL - the definitive data access language
  • PL/SQL - the premier language for running SQL in Oracle Database
  • Database design - a key skill for all database developers
Try a quiz
You need an Oracle Account to join Oracle Dev Gym. Click here to sign up.

Compete against others

Want to see how your skills stack up against experts around the world?

Every week we publish a new competitive quiz for you to test your knowledge. At the end of the week, we score each player on accuracy and speed. You can see how your skills stack up in the leaderboards. These searchable reports show the top-ranked players each week, month, quarter, and year.

At the end of each year, the highest-ranked players complete in a timed playoff in a bid to be crowned as the best Oracle Database developer.

Think you've got what it takes to be the best?

Take this week's quizzes

Train with free workouts

Like physical exercise, regular training is key to peak performance. To help with this, we've built targeted workouts to help you get to grips with specific topics in Oracle Database.
These training sessions enable you to up your skills on a specific topic. Along with our hand-crafted workouts, you can build your own around a theme and difficulty. This enables you to keep your database development muscles in shape.

Our top workouts

Free Oracle Database courses

Oracle Dev Gym includes complete classes to help you get started with SQL and PL/SQL programming

These guided programs all include videos to introduce the topic. These are complemented by articles or Live SQL tutorials. Each module finishes with a series of quizzes to check your understanding.

All courses on Oracle Dev Gym include a free certificate of completion.

Our top Oracle Database classes

Take free Oracle Database quizzes online

We have a library of thousands of quizzes. These are free, online, and available whenever you want.

You can practice anytime. Whether this is to hone your tournament skills or you want to train in a more relaxed environment we have quizzes to suit your ability.

Here's a sample Oracle Database quiz

Sample quiz (assume Oracle Database 10g Release 2 or higher)

You execute these statements:

  create table qz_bricks (
    brick_id integer
      not null primary key,
    colour   varchar2(10)
      not null,
    shape    varchar2(10)
      not null,
    weight   integer
      not null
  );

  insert into qz_bricks
    values ( 1, 'blue', 'cylinder', 1 );
  insert into qz_bricks
    values ( 2, 'blue', 'cylinder', 1 );
  insert into qz_bricks
    values ( 3, 'green', 'cube', 2 );
  insert into qz_bricks
    values ( 4, 'green', 'cylinder', 3 );
  insert into qz_bricks
    values ( 5, 'red', 'cube', 5 );
  insert into qz_bricks
    values ( 6, 'red', 'cube', 8 );
  insert into qz_bricks
    values ( 7, 'red', 'cylinder', 13 );

  commit;

Which queries find:

  • The total weight per shape
  • For rows with the colour red
  • Where the total weight per shape is greater than ten?

A correct choice returns these rows:

  SHAPE      TOTAL_WEIGHT
  ---------- ------------
  cube                 13
  cylinder             13

Choices - Select all that apply.

Choice 1

  select shape, sum ( weight ) total_weight
  from   qz_bricks
  where  colour = 'red'
  and    sum ( weight ) > 10
  group  by shape
  order  by shape;

Choice 2

  select shape, sum ( weight ) total_weight
  from   qz_bricks
  where  colour = 'red'
  group  by shape
  having sum ( weight ) > 10
  order  by shape ;

Choice 3

  select shape, sum ( weight ) total_weight
  from   qz_bricks
  group  by shape
  having sum ( weight ) > 10
  and    colour = 'red'
  order  by shape ;

Choice 4

  select shape, sum ( weight ) total_weight
  from   qz_bricks
  group  by shape
  having sum ( weight ) > 10
  and    max ( colour ) = 'red'
  order  by shape ;

Choice 5

  select shape, total_weight
  from   (
    select shape, sum ( weight ) total_weight
    from   qz_bricks
    where  colour = 'red'
    group  by shape
  )
  where  total_weight > 10
  order  by shape ;

No Choice Correct (Collapsible)

No choice is correct.

Take this quiz

Join the gym!

Whether you're starting out or an experienced Oracle expert, Oracle Dev Gym has a wealth of quizzes to take you to the next level.

So what are you waiting for? Get training today!

View quizzes