A.They need not return any values.

B.Functions can call only other functions.

C.They can appear in the select list of a SELECT statement.

D.They can be used in CONNECT BY and START WITH clauses.

E.They must be defined with at least one parameter.

F.They can be executed as standalone commands.

G.They can be used in ORDER BY and GROUP BY clauses.

A.A FUNCTION subprogram must return one or more values.

B.PROCEDURE subprograms can accept parameters.

C.FUNCTION subprograms must be called and passed through one or more parameters.

D.Anonymous blocks cannot use packaged variables.

E.Anonymous blocks must always start with the Declare keyword.

F.Named subprograms cannot be called from other packages.

G.Named subprograms are stored in the database server.

A.It must explicitly be declared.

B.It can be modified in the body of the loop.

C.It cannot be NULL.

D.It is accessible outside the body of the loop.

A.

B.

C.

D.

A.In a multitenant environment, the DELEGATE option of CBAC cannot be used.

B.CBAC cannot be used to secure definer's rights.

C.CBAC roles can be granted to a program unit only if they are directly granted to its owner.

D.You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

E.CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.

F.You can use CBAC to attach database roles to a PL/SQL function or procedure only.

G.In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.