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 2783

Which two statements are true about associative arrays and nested tables? (Choose two.)
 

Option A

A.    Only associative arrays can hold an arbitrary number of elements.
 

Option B

B.    Only associative arrays can use numbers and strings for subscripts.
 

Option C

C.    Both associative arrays and nested tables can hold an arbitrary number of elements.
 

Option D

D.    Both associative arrays and nested tables can use numbers and strings for subscripts.
 

Correct Answer B,C
Explanation


Question ID 2784

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!!!