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 - Which of the following is true about the following code snippet?

DECLARE
   a number(3) := 100;
BEGIN
   IF (a = 50 ) THEN
      dbms_output.put_line('Value of a is 10' );
   ELSEIF ( a = 75 ) THEN
      dbms_output.put_line('Value of a is 20' );
   ELSE
       dbms_output.put_line('None of the values is matching');
   END IF;
   dbms_output.put_line('Exact value of a is: '|| a ); 
END;

A - It has syntax error.

B - It will print 'None of the values is matching'.

C - It will print

None of the values is matching

Exact value of a is: 100

D - None of the above.

Q 4 - Which of the following is not true about the PL/SQL data structure VARRAY?

A - In oracle environment, the starting index for VARRAYs is always 1.

B - You can initialize the VARRAY elements using the constructor method of the VARRAY type, which has the same name as the VARRAY.

C - VARRAYs are one-dimensional arrays.

D - None of the above.

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

CREATE OR REPLACE FUNCTION totalCustomers
total number(2) := 0;
BEGIN
   SELECT count(*) into total
   FROM customers;
   RETURN total;
END;

A - It doesnt have the RETURN clause in function declaration.

B - The RETURN statement is wrong.

C - Function definition should not use the IS keyword

D - Nothing wrong.

Q 6 - Consider the exception declared as −

emp_exception1 EXCEPTION;

Which of the following statement will correctly call the exception in a PL/SQL block?

A - IF c_id <= 0 THEN ex_invalid_id;

B - IF c_id <= 0 THEN CALL ex_invalid_id;

C - IF c_id <= 0 THEN RAISE ex_invalid_id;

D - IF c_id <= 0 THEN EXCEPTION ex_invalid_id;

Q 7 - Which of the following is not true about PL/SQL triggers?

A - Triggers are stored programs.

B - They are automatically executed or fired when some events occur.

C - Triggers could be defined on the table, view, schema, or database with which the event is associated.

D - None of the above.

Q 8 - Any subprogram not in the package specification but coded in the package body is called a

A - Public object.

B - Private object.

C - None of the above.

D - Both 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 - What will be the output of the following code?

DECLARE
   lines dbms_output.chararr;
   num_lines number;
BEGIN
    dbms_output.enable;
   dbms_output.put_line('Hello!');
   dbms_output.put_line('Hope you are doing well!');
   num_lines := 2;
   dbms_output.get_lines(lines, num_lines);
 
   FOR i IN 1..num_lines LOOP
      dbms_output.put_line(lines(i));
   END LOOP;
END;

A - Hello!

     Hope you are doing well!

B - He

     Ho

C - Hello!

     Hope you

D - Hello!