A.Error in inner block Error in calling block

B.Error in inner block Error in outer block

C.Error in inner block Error in outer block Error in calling block

D.Error in inner block

A.AFTER SUSPEND

B.ROW

C.BEFORE STATEMENT

D.AFTER STATEMENT

A.OUT parameters returning values to calling subprograms act like constants in the called subprogram.

B.Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

C.PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

D.IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

E.The actual parameter must be a variable when calling a subprogram with an OUT parameter.

F.IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

G.IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

A.A function is deterministic if it always returns the same result for a specific combination of input values.

B.The PARALLEL_ENABLE clause can be specified for a nested function.

C.The NOCOPY hint asks the compiler to pass the actual parameters by value.

D.A deterministic function's results always depend on the state of session variables.

E.The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

F.The NOCOPY hint asks the compiler to pass the actual parameters by reference.

G.A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

A.WHEN

B.OPEN

C.CLOSE

D.OPEN-FOR

E.DECLARE

F.FETCH

G.INTO