AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 20576

Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)

Option A

It must be part of a package

Option B

It must be a pipelined table function

Option C

It must not be defined in an anonymous block

Option D

It must have at least one OUT or IN OUT parameter

Correct Answer C,D
Explanation


Question ID 20577

See the exhibit:

Examine the structure of DEPARTMENTS tables:

Examine the code that you plan to use for creating a package to obtain the details of an employee using a
host variable on the client side.
In SQL *Plus, you plan to use the following commands:

The package executes sucessfully and passes the required data to the host variables
Which statement is true about the above scenario?

Option A

The package executes sucessfully and passes the required data to the host variables

Option B

The package specification gives an error on compilation because cursor variable types cannot be
defined in the specification

Option C

The package specification gives an error on compilation because the cursor variable parameter waa
specified before you defined it

Option D

The package executes successfully but does not pass the required data to the host variable because
the cursor is closed before the PRINT statement runs 

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!