Hungry for free quizzes to practice your SQL skills? Get your fill on Oracle Dev Gym where we’ve expanded the range of quizzes available.

Guess the missing keyword quiz in Speed SQL

Test your knowledge of Oracle SQL against the clock in Speed SQL. This fast paced quiz gives you sixty seconds to guess the missing keyword (????) in each of a set of 10 SQL statements.

Speed SQL example: Guess the missing keyword (????) in: ALTER ???? users ADD ( photo BLOB NOT NULL, email VARCHAR2 (255) NOT NULL ) from the options TO_DATE, TABLE, TEMPORARY, STATEMENT_ID

For each statement you’re presented with four keywords. In the example above, you need to figure out what goes in place of the question marks in this ALTER command:

ALTER ???? users ADD ( photo BLOB NOT NULL, email VARCHAR2 (255) NOT NULL )

Below it are four keywords to choose from:

  • TO_DATE
  • TABLE
  • TEMPORARY
  • STATEMENT_ID

Pick which keyword you think is correct. You’ll be shown whether it’s right or wrong before the next statement loads. Below the choices is a series of ticks and crosses showing whether you got each one correct.

Once you’ve guessed every statement or the time has run out you’ll see a summary of your attempts. There will be a tick for each statement you got right and a cross for each incorrect keyword.

Speed SQL results screenshot

You can play as many times as you want. Keep trying until you get them all correct or see how fast you can complete the run.

Use the share buttons to copy your results to the clipboard to brag about your achievements. The best result is the most correct in the fastest time. So 10 correct in fifty seconds is better than 9 correct in forty seconds.

Come back the next day to see a summary of how many correct guesses every player made at the bottom of the results page.

If you have any questions, comments, or suggestions for improving Speed SQL, please get in touch. Use the feedback form located below your attempt summaries on the results page to send us your notes.

Play Speed SQL now to see how your Oracle SQL skills stack up. A new batch of statements for you to guess will be revealed at midnight UTC every day. Play every day to earn trophies showing your dedication.

Earn trophies for playing SQuizL and Speed SQL

Oracle Dev Gym has a wide range of trophies available for completing activities on the site. We’ve extended this to include regular play trophies for the Speed SQL and SQuizL quizzes.

Your latest achievements screenshot

You can now earn trophies for these challenges for playing every day in:

  • A week (Saturday – Friday)
  • A month (1st – last day)
  • A quarter (1st Jan/Apr/Jul/Oct – last day Mar/Jun/Sep/Dec)
  • A year (1st Jan – 31st Dec)

You can also earn a 100% correct trophy if you solve the SQuizL or get all the keywords correct in Speed SQL for each of these periods.

To earn trophies you must have a free Oracle account. Once you do, register on Oracle Dev Gym, sign in, and start playing! With a wide range of free database questions, tests, and classes, you’re bound to find something hone your abilities. Head to your Trophy Wall to admire all the progress you’ve made.