PL/SQL Online 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.

Q 2 - What value will be assigned to the variable declared as below −

counter binary_integer;

A - 0

B - 1

C - NULL

D - None of the above.

Q 3 - Which of the following is not true about labelling PL/SQL loops?

A - PL/SQL loops can be labelled.

B - The label should be enclosed by angle brackets (< and >).

C - The label name appears at the beginning of the LOOP statement.

D - The label name can also appear at the end of the LOOP statement or with an EXIT statement.

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;
PROCEDURE squareNum(x IN OUT number) IS
BEGIN
  x := x * x;
END; 
BEGIN
   a:= 5;
   squareNum(a);
   dbms_output.put_line(a);
END;

A - 5

B - 10

C - 25

D - 0

Q 6 - Which of the following is not true about PL/SQL records?

A - A PL/SQL record is a data structure that can hold data items of different kinds.

B - Records consist of different fields, similar to a row of a database table.

C - You can create table-based and cursor-based records by using the %ROWTYPE attribute.

D - None of the above.

Q 7 - Observe the syntax given below −

CREATE [OR REPLACE ] TRIGGER trigger_name 
{BEFORE | AFTER | INSTEAD OF } 
{INSERT [OR] | UPDATE [OR] | DELETE} 
[OF col_name] 
ON table_name 
[REFERENCING OLD AS o NEW AS n] 
[FOR EACH ROW] 
WHEN (condition)  
DECLARE
   Declaration-statements
BEGIN 
   Executable-statements
EXCEPTION
   Exception-handling-statements
END;

Which of the following holds true for the [REFERENCING OLD AS o NEW AS n] clause?

A - This allows you to refer new and old values for various DML statements, like INSERT, UPDATE, and DELETE.

B - OLD and NEW references are not available for table level triggers.

C - You can use them for record level triggers.

D - All of the above.

Q 8 - Which of the following is true about PL/SQL package body?

A - The package body has the codes for various methods declared in the package specification and other private declarations.

B - It is created using the CREATE PACKAGE Statement.

C - The codes, methods and types declared in package body are not hidden from code outside the package.

D - All of the above.

Q 9 - The collection method LAST

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 not true about object oriented PL/SQL?

A - It helps in designing object-oriented database in Oracle.

B - An object type allows you to crate composite types.

C - Objects are created using the CREATE [OR REPLACE] CLASS statement.

D - None of the above.