PL/SQL Online Quiz

Q 1 - Which of the following is not true about the PL/SQL language?

A - It supports embedded SQL statements.

B - It has all the features of a modern structured programming language.

C - It is not a block-structured language.

D - Applications developed using PL/SQL are not portable.

Q 2 - To get the server output result and display it into the screen, you need to write −

A - set serveroutput on

B - set server output on

C - set dbmsoutput on

D - set dbms output on

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

     5

     6

B - 4

     5

C - 4

D - None of the above.

Q 4 - Which of the following is not true about the PL/SQL data structure VARRAY?

A - It is a fixed-size sequential collection of elements.

B - The elements can of various data types.

C - It is used to store an ordered collection of data.

D - Each element in a VARRAY has an index associated with it.

Q 5 - What will be printed by the following PL/SQL block?

DECLARE
   a number;
   b number;
   c number;

PROCEDURE findMin(x IN number, y IN number, z OUT number) IS
BEGIN
   IF x < y THEN
      z:= x;
   ELSE
      z:= y;
   END IF;
END; 

BEGIN
   a:= 2;
   b:= 5;
   findMin(a, b, c);
   dbms_output.put_line(c);
END;

A - 2

B - 5

C - 0

D - Won’t print anything

Q 6 - The pre-defined exception NO_DATA_FOUND is raised when

A - A null object is automatically assigned a value.

B - A SELECT INTO statement returns no rows.

C - PL/SQL has an internal problem.

D - PL/SQL ran out of memory or memory was corrupted.

Q 7 - Which of the following is not true about PL/SQL triggers?

A - Triggers are stored programs.

B - They are automatically executed or fired when some events occur.

C - Triggers could be defined on the table, view, schema, or database with which the event is associated.

D - None of the above.

Q 8 - Which of the following statement will create the specification for a package named cust_sal

A -

CREATE PACKAGE BODY cust_sal AS
 PROCEDURE find_sal(c_id customers.id%type);
END cust_sal;

B -

CREATE PACKAGE cust_sal AS
 PROCEDURE find_sal(c_id customers.id%type);
END cust_sal;

C -

CREATE PACKAGE SPECIFICATION cust_sal AS
 PROCEDURE find_sal(c_id customers.id%type);
END cust_sal;

D -

PACKAGE cust_sal AS
 PROCEDURE find_sal(c_id customers.id%type);
END cust_sal;

Q 9 - The collection method LIMIT

A - Returns the last (largest) index numbers in a collection that uses integer subscripts.

B - Returns the number of elements that a collection currently contains.

C - Checks the Maximum Size of a Collection.

D - None of the above.

Q 10 - Which of the following is true about member methods?

A - Member methods are used for manipulating the attributes of the object.

B - Declaration of a member method is provided while declaring the object type.

C - The object body defines the code for the member methods.

D - All of the above.