最新的Oracle Database 19c: Program with PL/SQL - 1Z0-149免費考試真題

A. Explicit cursor can return more than one record.

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

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

D. Implicit cursor returns only one record.

E. %Isopen is always false in Implicit Cursor.

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

G. %Isopen is always false in Explicit Cursor.

A.

B.

C.

D.

A. line 4

B. line 5

C. line 3

D. line 6

E. line 2

A. Any optional parameters can be omitted in the invocation call.

B. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

C. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

D. Only trailing optional parameters can be omitted in the invocation call.

E. The actual parameters must be specified in the same order as the formal parameters are declared.

A. They must use labels.

B. They have the same effect on the execution of a loop.

C. They can be used in any type of loop.

D. They must have a WHEN condition.

A. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

B. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

C. If set to NATIVE, programs are stored in a PL/SQL bytecode format.

D. If set to NATIVE, programs are stored in platform dependent machine code.

E. The default value is NATIVE.

A.

B.

C.

D.