PRO - PL SQL Programming - Theory

Which of the following in incorrect regarding the FORALL statement?

1 Mark(s)

FORALL sends DML statements from PL/SQL to SQL in batches rather than one at a time
FORALL tells the PL/SQL runtime engine to bulk bind into the SQL statement all the elements of one or more collections before sending anything to the SQL engine
FORALL statement is a FOR LOOP
FORALL statement contains an iteration scheme

What does the integer indicate in the syntax below? TYPE arr_name IS VARRAY(integer) OF arr_type

1 Mark(s)

The lower bound of the varray
The upper bound of the varray
The current elements in the array
The maximum number of elements that the array can store

What does DELETE(m,n) do when applied on a collection variable?

1 Mark(s)

Deletes the mth and nth element of the collection.
Deletes element before mth place and after nth place
Deletes elements in the range of m to n
Throws an error. This form is not supported for DELETE.

What happens when the data type of the actual parameter is not the same as the data type of the formal parameter?

1 Mark(s)

An error is thrown
The parameter is skipped and not passed.
Compiler performs an implicit conversion and if possible no error is thrown.
The PL/SQL code abruptly terminates.

What are the methods used to navigate across a varray in the forward and reverse directions?

1 Mark(s)

BEFORE and AFTER
BEFORE and NEXT
FIRST and LAST
PRIOR and NEXT

How can a nested table be traversed?

1 Mark(s)

Using COUNT and LIMIT methods
Using FIRST and LAST methods
Using FIRST and NEXT methods
Using FIRST and COUNT methods

What is the result of overloading of these two procedures? PROCEDURE s (p INTEGER) IS … PROCEDURE s (p REAL) IS … Successful Error because formal parameters differ only in mode Error because the name of the procedures are same Error because formal parameters differ only in subtype

1 Mark(s)

Successful
Error because formal parameters differ only in mode
Error because the name of the procedures are same
Error because formal parameters differ only in subtype

What are the various forms of EXISTS method?

1 Mark(s)

EXISTS only
EXISTS ,EXISTS(m.n) and EXISTS(n)
EXISTS(n) only
EXISTS and EXISTS(n)

What is the syntax of an implicit cursor attribute ISOPEN?

1 Mark(s)

%ISOPEN
#ISOPEN
&ISOPEN
!ISOPEN

What is the state of an uninitialized associative array variable?

1 Mark(s)

Error
NULL
Undefined
Empty

What happens when we specify parameters using named notations in wrong order?

1 Mark(s)

There is no wrong order while using named notations
This can cause problems that are hard to detect.
These problems are detected using PL/SQL compiler
Run time errors are thrown when such a problem occurs

For which of the following statements can a CURRENT OF clause be used?

1 Mark(s)

INSERT, DELETE or UPDATE
DELETE or UPDATE
SELECT or INSERT
SELECT or UPDATE

What is the datatype of the return value of SQL%ROWCOUNT attribute?

1 Mark(s)

INTEGER
NUMBER
PLS_INTEGER
BOOLEAN

What is SYS_REFCURSOR?

1 Mark(s)

A user defined REF CURSOR that is weakly typed
A predefined REF CURSOR that is weakly typed
A predefined REF CURSOR that is strongly yped
A user defined REF CURSOR that is strongly typed

When does the compiler implicitly convert the data type of the actual parameter to the data type of the formal parameter?

1 Mark(s)

When passed by reference
Always, when passed by any method
It never converts implicitly and has to be explicitly done by user
When passed by value

What happens if a stored subprogram exits with an unhandled exception?

1 Mark(s)

PL/SQL rolls back database changes made by the subprogram
PL/SQL does not roll back database changes made by the subprogram
PL/SQL commits database changes made by the subprogram.
PL/SQL removes the subprogram from the database.

Into which of the following type of variables does all BULK operations in PL/SQL fetch data?

1 Mark(s)

Scalar
Collection
Records
User defined types

How is the Loop index of a CURSOR FOR LOOP declared?

1 Mark(s)

It is explicitly declared as a %TYPE record variable of the type that its cursor returns.
It is implicitly declared as a %TYPE record variable of the type that its cursor returns.
It is explicitly declared as a %ROWTYPE record variable of the type that its cursor returns.
It is implicitly declared as a %ROWTYPE record variable of the type that its cursor returns

What does the lower bound and upper bound of FORALL statement indicate?

1 Mark(s)

They are numbers implicitly assigned by the PL/SQL engine
They must specify a valid range of consecutive index numbers for the variables referenced in the SQL statement.
They must be constant numbers explicitly assigned
They must specify a valid range of consecutive index numbers for the collection referenced in the SQL statement

What does the integer indicate in the syntax below? TYPE arr_name IS VARRAY(integer) OF arr_type

1 Mark(s)

The lower bound of the varray
The upper bound of the varray
The current elements in the array
The maximum number of elements that the array can store

PRO - PL SQL Programming - Theory - 10 : Question 1 of 20