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 2835

Which two statements are true about the usage of the
DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
 

Option A

A.    You can describe remote objects.
 

Option B

B.    You can describe anonymous PL/SQL blocks.
 

Option C

C.    You can describe a stored procedure, stored function, packaged procedure, or packaged function.
 

Option D

D.    You can obtain information about the position, name, and data type of the arguments of a procedure.
 

Correct Answer C,D
Explanation


Question ID 2836

You executed the following command to alter the session parameter:
SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'; Which two statements are true in this scenario? (Choose two.)

 

Option A

A.    If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.
 

Option B

B.    All the identifiers declared in compiled program units before altering the parameter settings appear in the *_IDENTIFIER static data dictionary views.
 

Option C

C.    All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.
 

Option D

D.    If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects data for the compiled object and stores it in the SYSTEM tablespace.

Correct Answer A,C
Explanation

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