PL/SQL Online Quiz

Following quiz provides Multiple Choice Questions (MCQs) related to PL/SQL. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Q 1 - Which of the following is not a PL/SQL unit?

Answer : A

Q 2 - What is wrong in the following code?

DECLARE
   c_id := 1;
   c_name  customers.name%type;
   c_addr customers.address%type;
  BEGIN
   SELECT name, address INTO c_name, c_addr
   FROM customers
   WHERE id = c_id;
END;

A - You cannot use the SELECT INTO statement of SQL to assign values to PL/SQL variables.

B - The SELECT INTO statement here is wrong. It should be: SELECT c_name, c_address INTO name, addr

C - The WHERE statement is wrong. It should be: WHERE id := c_id;

D - The variable c_id should be declared as a type-compatible variable as −

c_id customers.id%type := 1;

Answer : D

Q 3 - What is the output of the following code?

DECLARE
   x number := 4;
BEGIN
   LOOP
      dbms_output.put_line(x);
      x := x + 1;
      exit WHEN x > 5;
   END LOOP;
      dbms_output.put_line(x);
END;

A - 4

B - 4

C - 4

D - None of the above.

Answer : A

Q 4 - Consider a variable named greetings declared as −

greetings varchar2(11) := 'Hello World';

What will be the output of the code snippet

dbms_output.put_line ( SUBSTR (greetings, 7, 5));

A - World

B - Hello

C - orld

D - None of the above.

Answer : A

Q 5 - What would be the output of the following code?

DECLARE
   num number;
   fn number;

FUNCTION fx(x number)
RETURN number 
IS
   f number;
BEGIN
   IF x=0 THEN
      f := 1;
   ELSE
      f := x * fx(x-1);
   END IF;
RETURN f;
END;

BEGIN
   num:= 5;
   fn := fx(num);
   dbms_output.put_line(fn);
END;