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

A - PL/SQL loops can be labelled.

B - The label should be enclosed by angle brackets (< and >).

C - The label name appears at the beginning of the LOOP statement.

D - The label name can also appear at the end of the LOOP statement or with an EXIT statement.

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 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 - Which of the following is not among the types of PL/SQL records?

A - Table-based

B - View-based

C - Cursor-based records

D - User-defined records

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

A - The specification is the interface to the package.

B - It declares the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package.

C - It contains all information about the content of the package and the code for the subprograms.

D - None of the above.

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

A - These are functions that return a new object as its value.

B - Every object has a system defined constructor method.

C - The name of the constructor is same as the object type.

D - None of the above.