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 - Consider the following code −

DECLARE
   -- Global variables 
   num number := 95; 
BEGIN 
   dbms_output.put_line('num: ' || num1);
   DECLARE 
      -- Local variables
      num number := 195; 
     BEGIN 
      dbms_output.put_line('num: ' || num1);
     END; 
END;

What will happen when the code is executed?

A - It won’t execute, it has syntax error

B - It will print

     num: 95

     num: 195

C - It will print

     num: 95

     num: 95

D - It will print

     num: 195

     num: 195

Q 3 - Which of the following is not true about PL/SQL loop structures?

A - In the basic loop structure, sequence of statements is enclosed between the LOOP and END LOOP statements.

B - The WHILE loop repeats a statement or group of statements while a given condition is true.

C - The FOR loop executes a sequence of statements multiple times and abbreviates the code that manages the loop variable.

D - Nesting of loops is not allowed.

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 PL/SQL cursors?

A - A cursor is a view on a table.

B - A cursor holds the rows (one or more) returned by a SQL statement.

C - The set of rows the cursor holds is referred to as the active set.

D - None of the above.

Q 6 - Which of the following code correctly create a record named book with two field title and author?

A - TYPE book IS RECORD

(title  varchar(50),
    author  varchar(50),
    );

B - RECORD book

(title  varchar(50),
    author  varchar(50),
    );

C - CREATE RECORD book

(title  varchar(50),
    author  varchar(50),
    );

D - CREATE TYPE book

(title  varchar(50),
    author  varchar(50),
    );

Q 7 - Which of the following is true for querying a table in the same trigger?

A - The AFTER keyword should be used, because triggers can query the table or change it again only after the initial changes are applied and the table is back in a consistent state.

B - The BEFORE keyword should be used, because triggers can query the table or change it again only after the initial changes are applied and the table is back in a consistent state.

C - None of the points in a. and b.

D - Both of the points in a. and b.

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 not true about database transactions?

A - A database transaction is an atomic unit of work.

B - It may consist of one or more related SQL statements.

C - A successfully executed SQL statement and a committed transaction are not same.

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.