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 true about character data types and subtypes in PL/SQL?

A - LONG is a variable-length character string with maximum size of 32,760 bytes.

B - ROWID is a physical column identifier, the address of a column in an ordinary table.

C - CHAR is a variable-length character string with maximum size of 32,767 bytes.

D - NCHAR is a variable-length national character string with maximum size of 32,767 bytes.

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 the correct syntax for creating a VARRAY named grades, which can hold 100 integers, in a PL/SQL block?

A - TYPE grades IS VARRAY(100) OF INTEGERS;

B - VARRAY grades IS VARRAY(100) OF INTEGER;

C - TYPE grades VARRAY(100) OF INTEGER;

D - TYPE grades IS VARRAY(100) OF INTEGER;

Q 5 - Which of the following is a way of passing parameters to PL/SQL subprograms?

A - Positional notation

B - Named notation

C - Mixed notation

D - All 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 - The pre-defined exception TOO_MANY_ROWS is raised when

A - PL/SQL ran out of memory or memory was corrupted.

B - A cursor fetches value in a variable having incompatible data type.

C - SELECT INTO statement returns more than one row.

D - None 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 - Which of the following is true about database transactions?

A - The SQL statements that constitute a transaction can collectively be either committed, i.e., made permanent to the database or rolled back (undone) from the database.

B - A transaction has a beginning and an end.

C - None of the above.

D - Both of the above.

Q 10 - Which of the following is true about the inheritance for PL/SQL Objects?

A - PL/SQL allows creating object from existing base objects.

B - To implement inheritance, the base objects should be declared as NOT FINAL.

C - The NOT INSTANTIABLE clause allows you to declare an abstract object.

D - All of the above.