PL/SQL Online Quiz

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

A - It supports embedded SQL statements.

B - It has all the features of a modern structured programming language.

C - It is not a block-structured language.

D - Applications developed using PL/SQL are not portable.

Q 2 - Which of the following is not true about large object data types and in PL/SQL?

A - BFILE is used to store large binary objects in operating system files outside the database.

B - BLOB is used to store character data in the database.

C - CLOB is used to store large blocks of character data in the database.

D - NCLOB is used to store large blocks of NCHAR data in the database.

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 - Which of the following is not true about the PL/SQL data structure VARRAY?

A - It is a fixed-size sequential collection of elements.

B - The elements can of various data types.

C - It is used to store an ordered collection of data.

D - Each element in a VARRAY has an index associated with it.

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 not true about PL/SQL records?

A - A PL/SQL record is a data structure that can hold data items of different kinds.

B - Records consist of different fields, similar to a row of a database table.

C - You can create table-based and cursor-based records by using the %ROWTYPE attribute.

D - None of the above.

Q 7 - Triggers are written to be executed in response to any of the following events −

A - A database manipulation (DML) statement (DELETE, INSERT, or UPDATE).

B - A database definition (DDL) statement (CREATE, ALTER, or DROP).

C - A database operation (SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN).

D - All of the above.

Q 8 - Which of the following is true about PL/SQL index-by tables?

A - It is a set of key-value pairs.

B - Each key is unique and is used to locate the corresponding value.

C - The key can be either an integer or a string.

D - All of the above.

Q 9 - The collection method LAST

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 - Which of the following code will create an object type named local_address with two field house_no and street?

A -

CREATE OR REPLACE OBJECT local_address 
(house_no varchar2(10),
 street varchar2(30),
 );

B -

CREATE OR REPLACE TYPE local_address AS OBJECT
(house_no varchar2(10),
 street varchar2(30),
 );

C -

CREATE OR REPLACE OBJECT  local_address AS 
(house_no varchar2(10),
 street varchar2(30),
 );

D -

CREATE OR REPLACE CLASS local_address 
(house_no varchar2(10),
 street varchar2(30),
 );