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 true about the declaration section of a PL/SQL block?

A - This section starts with the DECLARE keyword.

B - It is a mandatory section.

C - It defines all variables, cursors, subprograms, and other elements to be used in the program.

D - None of the above.

Answer : B

Q 2 - Which of the following is true about character data types and subtypes in PL/SQL?

A - LONG is a variable-length character string with maximum size of 32,760 bytes.

B - ROWID is a physical column identifier, the address of a column in an ordinary table.

C - CHAR is a variable-length character string with maximum size of 32,767 bytes.

D - NCHAR is a variable-length national character string with maximum size of 32,767 bytes.

Answer : A

Q 3 - Which of the following is not true about PL/SQL loop structures?

A - In the basic loop structure, sequence of statements is enclosed between the LOOP and END LOOP statements.

B - The WHILE loop repeats a statement or group of statements while a given condition is true.

C - The FOR loop executes a sequence of statements multiple times and abbreviates the code that manages the loop variable.

D - Nesting of loops is not allowed.

Answer : D

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;