PL/SQL Online Quiz

Q 1 - Which of the following is not true about the exception handling section of a PL/SQL block?

A - This section starts with the EXCEPTION keyword.

B - It is a mandatory section.

C - It contains exception(s) that handle errors in the program.

D - None 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 - Which of the following is true about the following PL/SQL CASE statement syntax?

CASE selector
    WHEN 'value1' THEN S1;
    WHEN 'value2' THEN S2;
    WHEN 'value3' THEN S3;
    ...
    ELSE Sn;  -- default case
END CASE;

A - It is wrongly written.

B - It is perfectly written.

C - It is you can specify the literal NULL for all the S expressions and the default S_n.

D - All the expressions like the selector, the value and the returns values, need not be of the same data type.

Q 4 - Consider the following code snippet: how many times the loop will run?

DECLARE
   a number(2) := 9;
BEGIN
   WHILE a < 30 LOOP
      a := a + 3;
   END LOOP;
END;

A - 10

B - 8

C - 7

D - 9

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 following code tries to fetch some information from all the rows in a table named customers for use in a PL/SQL block. What is wrong in the following code?

DECLARE
   c_id customers.id%type;
   c_name customers.name%type;
   c_addr customers.address%type;
   CURSOR c_customers is
      SELECT id, name, address FROM customers;
BEGIN
   LOOP
      FETCH c_customers into c_id, c_name, c_addr;
      EXIT WHEN c_customers%notfound;
      dbms_output.put_line(c_id || ' ' || c_name || ' ' || c_addr);
   END LOOP;
   CLOSE c_customers;
END;

A - It need not use a cursor.

B - The cursor is not opened.

C - It will not print information from all the rows.

D - There is nothing wrong in the code.

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 is a PL/SQL collection types?

A - Index-by tables or Associative array

B - Nested table

C - Variable-size array or Varray

D - All of the above.

Q 9 - A transaction starts when

A - The first SQL statement is performed after connecting to the database.

B - At each new SQL statement issued after a transaction is completed.

C - None of the above.

D - Both of the above.

Q 10 - The following code tries to create a base object named rectangle, which will be inherited. What is wrong in the code?

CREATE OR REPLACE TYPE rectangle AS OBJECT
(length number,
 width number,
 member function enlarge( inc number) return rectangle,
 NOT FINAL member procedure display) 

A - The declaration should read as CREATE OR REPLACE OBJECT rectangle AS …

B - The base object should not have any member attribute or functions.

C - The base object rectangle should be declared as NOT FINAL.

D - None of the above