A Dev Gym Workout

Oracle Database 21c SQL Quizzes


Want to know what's new for SQL and PL/SQL in Oracle Database 21c?

Take these free quizzes to learn how 21c makes it easier to initialize and loop through arrays, simplifies updating JSON documents, improves SQL window functions, and enables you to define reusable SQL expressions.

  • Instructor

    Chris Saxon*

  • Estimated Time

    9 Minutes

  • Difficulty

    Intermediate to Advanced

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Exercises

Exercise Difficulty Time
Quiz on The FOR LOOP StatementIntermediate1
Quiz on Qualified Expressions for Associative ArraysIntermediate1
Quiz on SQL MacrosIntermediate1
Quiz on Windowing clauseIntermediate1
Quiz on JSON Data TypeIntermediate1
Quiz on MINUS / EXCEPT OperatorIntermediate1
Quiz on ANY_VALUEIntermediate1
Quiz on JSON_TRANSFORMAdvanced1
Quiz on WINDOWAdvanced1
Instructor

*About Chris Saxon

Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.

More from Chris Saxon