VF=>user  ID=>     Login Feedback FAQ Blog
1,045,685 quizzes played | 1,431 active players

      Important News!

      We've built a new "skin" for our quiz platform: the Oracle Dev Gym. We'd love to hear what you think of it. Click on the Dev Gym image on the right of your home page to check it out.

      Welcome to the PL/SQL Challenge!

      Take quizzes, explore the library, check out player rankings!

      What Players Say About the PL/SQL Challenge

      "I try every morning to answer the quiz before I start opening my work emails. It actually jump starts my brain in the morning!"

      "Thanks for this wonderful site. it has become a nice evening routine to answer the question and sharpen my skills."

      "I really appreciate Oracle providing these quizzes. I use them to improve my Oracle Database development skills, and to learn about features I have not yet taken advantage of."

      "Great SQL quiz this week! I got it wrong, but I learned something new. :-)"

      Play This Week's Quizzes

      Already registered, ready to play? Then click on a button to be logged in and play the quiz right now.

      Try a Quiz!

      We are all about active learning! Rather than passively read or watch, you test your knowledge by answering a quiz and (if you choose) competing with Oracle Database developers around the world for top ranking.

      I compile the following package:

      PACKAGE plch_pkg
         my_flag BOOLEAN := TRUE;

      Which of the choices will display "TRUE" after execution?

      Choice 1
         DBMS_OUTPUT.PUT_LINE (plch_pkg.my_flag);

      Choice 2
         DBMS_OUTPUT.PUT_LINE (CASE WHEN plch_pkg.my_flag THEN 'TRUE' END);

      Choice 3
         DBMS_OUTPUT.PUT_LINE (CASE WHEN plch_pkg.my_flag THEN 'FALSE' END);
      About Oracle | Terms of Use | Your Privacy Rights | Copyright 2010-2017, Oracle Corporation