PL/SQL Online Quiz

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

A - Comments are explanatory statements.

B - PL/SQL supports both single-line and multi-line comments.

C - The PL/SQL single-line comments start with the delimiter -- (double hyphen) and multi-line comments are enclosed by /* and */.

D - All of the above.

Q 2 - Which of the following is not true about PL/SQL constants and literals?

A - A constant holds a value that once declared, does not change in the program.

B - The CONSTANT declaration cannot impose the NOT NULL constraint.

C - A constant is declared using the CONSTANT keyword.

D - A CONSTANT declaration requires an initial value.

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 - Consider the following code snippet: what will be the output?

DECLARE
   a number(2) ;
BEGIN
   FOR a IN REVERSE 10 .. 20 LOOP
   END LOOP;
dbms_output.put_line(a);
END;

A - 11

B - 10

C - 29

D - 30

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 - Which of the following code will successfully declare an exception named emp_exception1 in a PL/SQL block?

A - EXCEPTION emp_exception1;

B - emp_exception1 EXCEPTION;

C - CREATE EXCEPTION emp_exception1;

D - CREATE emp_exception1 AS EXCEPTION;

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 WHEN clause?

A - This provides a condition for rows for which the trigger would fire and this clause is valid only for row level triggers.

B - This provides a condition for rows for which the trigger would fire and this clause is valid only for table level triggers.

C - This provides a condition for rows for which the trigger would fire and this clause is valid only for view based triggers.

D - All of the above.

Q 8 - Which of the following syntax will be used to access a package element?

A - package_name element_name;

B - element_name.package_name;

C - package_name.element_name;

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 - 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.