VF=>user  ID=>     Login Feedback FAQ Blog
992,228 quizzes played | 1,747 active players

      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 create this package specification:

      CREATE OR REPLACE PACKAGE plch_pkg
      IS
         TYPE numbers_t IS TABLE OF NUMBER;
         lotsa_dups   numbers_t
                         := numbers_t (1, 1, 2, 2, 3, 3);
         no_dups      numbers_t := numbers_t (1, 2, 3);
      END;
      /

      Which choice displays "Contained" after execution?

      BEGIN
         IF plch_pkg.lotsa_dups SUBMULTISET OF plch_pkg.no_dups
         THEN
            DBMS_OUTPUT.put_line ('Contained');
         ELSE
            DBMS_OUTPUT.put_line ('Escaped');
         END IF;
      END;
      /
      
      BEGIN
         IF plch_pkg.no_dups SUBMULTISET OF plch_pkg.lotsa_dups
         THEN
            DBMS_OUTPUT.put_line ('Contained');
         ELSE
            DBMS_OUTPUT.put_line ('Escaped');
         END IF;
      END;
      /
      
      DECLARE
         l_numbers   plch_pkg.numbers_t
            := plch_pkg.lotsa_dups MULTISET EXCEPT 
               plch_pkg.no_dups;
      BEGIN
         IF l_numbers.COUNT = 0
         THEN
            DBMS_OUTPUT.put_line ('Contained');
         ELSE
            DBMS_OUTPUT.put_line ('Escaped');
         END IF;
      END;
      /
      
       
      About Oracle | Terms of Use | Your Privacy Rights | Copyright 2010-2016, Oracle Corporation