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

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

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

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

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

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

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

A.line 5

B.line 2

C.line 6

D.line 4

E.line 3

A.DECLARE

B.CLOSE

C.OPEN-FOR

D.WHEN

E.OPEN

F.INTO

G.FETCH

A.

B.

C.

D.

A.INDEX-BY table types can be created in PL/SQL blocks only.

B.The index can be integer or string.

C.INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

D.INDEX-BY table types can be created with the CREATE TYPE statement.

E.The index can be integer only.