PL/SQL Online Quiz

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

A - PL/SQL provides access to predefined SQL packages.

B - PL/SQL provides support for Object-Oriented Programming.

C - PL/SQL provides support for Developing Web Applications and Server Pages.

D - All of the above.

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

A - They hold single values with no internal components.

B - Examples of scalar data types are NUMBER, DATE, or BOOLEAN.

C - PL/SQL provides subtypes of data types.

D - All are true.

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 true about the PL/SQL data structure VARRAY?

A - It also has a maximum size that cannot be changed.

B - A VARRAY type is created with the CREATE VARRAY statement, at the schema level.

C - Maximum size of a VARRAY can be changed using the ALTER TYPE statement.

D - Maximum size of a VARRAY can be changed using the ALTER VARRAY statement.

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

DECLARE
   a number;
   b number;
   c number;
FUNCTION fx(x IN number, y IN number) 
RETURN number
IS
    z number;
BEGIN
   IF x > 2*y THEN
      z:= x;
   ELSE
      z:= 2*y;
   END IF;

   RETURN z;
END; 
BEGIN
   a:= 23;
   b:= 47;

   c := fx(a, b);
   dbms_output.put_line(c);
END;

A - 46

B - 47

C - 94

D - 23

Q 6 - Which of the following is the correct syntax for creating an explicit cursor?

A - CURSOR cursor_name IS select_statement;

B - CREATE CURSOR cursor_name IS select_statement;

C - CREATE CURSOR cursor_name AS select_statement;

D - CURSOR cursor_name AS select_statement;

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;

The {INSERT [OR] | UPDATE [OR] | DELETE} clause specifies a

A - DDL operation.

B - DML operation.

C - None of the above.

D - Both of the above.

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

A - A collection is an ordered group of elements having the same data type.

B - A collection is an ordered group of elements having different data type.

C - Each element is identified by a unique subscript that represents its position in the collection.

D - Nested tables and Varrays are types of PL/SQL collections.

Q 9 - Which of the following is true about database transactions?

A - The SQL statements that constitute a transaction can collectively be either committed, i.e., made permanent to the database or rolled back (undone) from the database.

B - A transaction has a beginning and an end.

C - None of the above.

D - Both of the above.

Q 10 - A transaction ends when

A - A COMMIT or a ROLLBACK statement is issued.

B - A DDL statement, like CREATE TABLE statement, is issued; because in that case a COMMIT is automatically performed.

C - A DCL statement, such as a GRANT statement, is issued; because in that case a COMMIT is automatically performed.

D - All of the above.