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 - Consider the following code −

DECLARE
   -- Global variables 
   num number := 95; 
BEGIN 
   dbms_output.put_line('num: ' || num1);
   DECLARE 
      -- Local variables
      num number := 195; 
     BEGIN 
      dbms_output.put_line('num: ' || num1);
     END; 
END;

What will happen when the code is executed?

A - It won’t execute, it has syntax error

B - It will print

     num: 95

     num: 195

C - It will print

     num: 95

     num: 95

D - It will print

     num: 195

     num: 195

Q 3 - What is wrong in the following code snippet?

DECLARE
   x number := 1;
BEGIN
   LOOP
      dbms_output.put_line(x);
      x := x + 1;
      IF x > 10 THEN
         exit;
      END IF;
     dbms_output.put_line('After Exit x is: ' || x);
END;

A - There is nothing wrong.

B - The IF statement is not required.

C - There should be an END LOOP statement.

D - The exit statement should be in capital letters.

Q 4 - Which of the following is the correct syntax for creating a VARRAY named grades, which can hold 100 integers, in a PL/SQL block?

A - TYPE grades IS VARRAY(100) OF INTEGERS;

B - VARRAY grades IS VARRAY(100) OF INTEGER;

C - TYPE grades VARRAY(100) OF INTEGER;

D - TYPE grades IS VARRAY(100) OF INTEGER;

Q 5 - Which of the following is not true about the PL/SQL functions?

A - A PL/SQL function is same as a procedure except that it returns a value.

B - The function body must contain a RETURN statement.

C - The RETURN clause does not specify the data type of the return value.

D - The AS keyword is used instead of the IS keyword for creating a standalone function.

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

A - None of the choices in the WHEN clauses of a CASE statement is selected, and there is no ELSE clause.

B - PL/SQL has an internal problem.

C - A cursor fetches value in a variable having incompatible data type.

D - None of the above.

Q 7 - Which of the following is not a benefit of a database trigger?

A - Enforcing referential integrity

B - Event logging and storing information on table access

C - Allowing invalid transactions

D - Generating some derived column values automatically

Q 8 - Which of the following is not true about PL/SQL packages?

A - PL/SQL packages are schema objects that groups logically related PL/SQL types, variables and subprograms.

B - A package has two parts: Package specification and Package body or definition.

C - Both the parts are mandatory.

D - None of the above.

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 code will create an object type named local_address with two field house_no and street?

A -

CREATE OR REPLACE OBJECT local_address 
(house_no varchar2(10),
 street varchar2(30),
 );

B -

CREATE OR REPLACE TYPE local_address AS OBJECT
(house_no varchar2(10),
 street varchar2(30),
 );

C -

CREATE OR REPLACE OBJECT  local_address AS 
(house_no varchar2(10),
 street varchar2(30),
 );

D -

CREATE OR REPLACE CLASS local_address 
(house_no varchar2(10),
 street varchar2(30),
 );