Oracle Database 19c: Program with PL/SQL - 1Z0-149 模擬練習

A. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.

B. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.

C. Host variables can be referenced inside any PL/SQL subprogram.

D. Subprograms are cached by default and shared among users, thereby reducing memory requirements.

E. A PL/SQL procedure can invoke an external code block written in a different programming language.

F. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

G. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.

A. OPEN-FOR

B. FETCH

C. INTO

D. WHEN

E. DECLARE

F. OPEN

G. CLOSE

A. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

B. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

C. Package specifications can be compiled without their bodies.

D. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

E. A package definition must have a specification and body.

A. BEFORE STATEMENT

B. ROW

C. AFTER STATEMENT

D. AFTER SUSPEND

A. The check is enforced by this clause for direct access and access through dynamic SQL.

B. It can be used for individual procedures and functions declared in a package specification.

C. It can be used in the declaration of object types.

D. It must be specified in the heading of a package specification.

E. It must be specified in the heading of a package body.

A.

B.

C.

D.

A. 15000

B. 10000

C. 5000

D. 2500