최신Oracle Database 19c: Program with PL/SQL - 1Z0-149무료샘플문제

A. Package specifications can be compiled without their bodies.

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

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

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

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

A. line 2

B. line 4

C. line 6

D. line 5

E. line 3

A. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

B. %Isopen is always false in Implicit Cursor.

C. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

E. Implicit cursor returns only one record.

F. Explicit cursor can return more than one record.

G. %Isopen is always false in Explicit Cursor.

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

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

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

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

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

A. line 2

B. line 6

C. line 1

D. line 7

E. line 3

F. line 8

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

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

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

D. The index can be integer or string.

E. The index can be integer only.

A. It returns an error in line 9.

B. It returns an error in line 4.

C. It executes and displays output.

D. It returns an error in line 2.